Interested to Buy Any Domain ? << Click Here >> for more details...
how to sort two columns in single job in datastage.
- 1 Answers
- 11077 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are data elements?
Define ds designer?
What is the purpose of pivot stage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is the method of removing duplicates, without the remove duplicate stage?
Define Merge?
How many types of views are there in a datastage director?
To see hidden files in LINIX?
Differentiate between Join, Merge and Lookup stage?
What are the functionalities of link partitioner and link collector?
What are the types of views in datastage director?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What are the different options associated with dsjob command?
What are the types of jobs we have in datastage?
