how to sort two columns in single job in datastage.
- 1 Answers
- 10224 Views
- TCS, I also Faced
- E-Mail Answers
Answer / srinivas
We can do this by using the sort stage.
Specify the key columns what ever the you are sort.
Specify column name sort specifications
For example i have 3 columns data like below
Name score rank
abc 85 1
bcd 74 3
abc 82 2
bcd 67 4
When u r sort based on first two colmns
u have to specify two colmn names and specificaton
Like: Name Asc, Score Dsc.
Then u will get the output like below.
Name score rank
abc 85 1
abc 82 2
bcd 74 3
bcd 67 4
| Is This Answer Correct ? | 2 Yes | 1 No |
What are the various kinds of containers available in datastage?
Difference between sequential file and data set?
How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition
How can we improve performance of data stage jobs?
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
How many number of reject links merge stage can have?
How to display errors in datastage?
Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
How you Remove the Dataset in Unix?
Differentiate between Join, Merge and Lookup stage?
specify data stage strength?
Teradata 
