Interested to Buy Any Domain ? << Click Here >> for more details...
how to sort two columns in single job in datastage.
- 1 Answers
- 10974 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 many types of sorting methods are available in datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Name the third party tools that can be used in datastage?
What are sequencers?
how do u catch bad rows from OCI stage? And what CLI stands for?
AGGREGATOR default datatype
Define project in datastage?
How to read the length of word in unix?
Differentiate between datastage and informatica?
What is the difference between informatica and datastage?
What is ibm datastage flow designer?
What is a folder? Difference types of stages?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
