Interested to Buy Any Domain ? << Click Here >> for more details...
how to sort two columns in single job in datastage.
- 1 Answers
- 11171 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
How to find value from a column in a dataset?
What is a ds designer?
What are the some differences between 7.x and 8.x version of datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are routines in datastage?
How do you schedule or monitoring the job?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Can you explain engine tier in information server?
What are the various kinds of containers available in datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
How to perform incremental load in datastage?
What are some prerequisites for datastage?
what is repositery?
What are stage variables and constants?
What are the steps needed to create a simple basic datastage job?
