regarding sort stage
Posted: Mon Dec 18, 2006 1:59 pm
Hi,
odbc----->sort----->odbc
iam using sort stage , in the properties tab of sort stage.
when i enter IN THE SORT SPECIFICATIONS I ENTERED---MGR ASC.
MGR-IS THE I/P COLUMN IN MY SOURCE TABLE.
in the target table i can see the data organised by itself, what i mean is that i thought if i enter MGR ASC- It only sorts that particular column only.
but it organises another column too.
b/f sort after sort
JOB MGR JOB MGR
SALESMA N 7902 MANAGER 7605
MANAGER 7605 SALESMAN 7902
i just want to know why does it sort another columns too,it because the inorder to maintain the meaningful data.
bz in the sort specifications i just entered --- mgr asc.
when i design
odbc--->aggregator---->odbc
CONNECTED the same ODBC to sort and then sequential file.
why isn't it tansfering the records to sort component.
it just transfering the records to aggregate component.
plz help me in analyzing.
cheers;
abhi
odbc----->sort----->odbc
iam using sort stage , in the properties tab of sort stage.
when i enter IN THE SORT SPECIFICATIONS I ENTERED---MGR ASC.
MGR-IS THE I/P COLUMN IN MY SOURCE TABLE.
in the target table i can see the data organised by itself, what i mean is that i thought if i enter MGR ASC- It only sorts that particular column only.
but it organises another column too.
b/f sort after sort
JOB MGR JOB MGR
SALESMA N 7902 MANAGER 7605
MANAGER 7605 SALESMAN 7902
i just want to know why does it sort another columns too,it because the inorder to maintain the meaningful data.
bz in the sort specifications i just entered --- mgr asc.
when i design
odbc--->aggregator---->odbc
CONNECTED the same ODBC to sort and then sequential file.
why isn't it tansfering the records to sort component.
it just transfering the records to aggregate component.
plz help me in analyzing.
cheers;
abhi