Interested to Buy Any Domain ? << Click Here >> for more details...
Hi guys,
7. how to get this output
i/p
col1,col2
101,a
102,b
103,c
104,d
o/p
col1,col2
101,d
102,c
103,b
104,a
Thanks
- 2 Answers
- 9750 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / anil
1. Take a copy of the file in two links where id only in one link and value in another link.
2. For id link add a column generator for giving row number(Temp). Run this in sequential mode. Parition by Sort Merge (ascending)
3. For value link add a column generator for giving row number(Temp). Run this in sequential mode. Parition by Sort Merge (descending).
4. Now add look up between two columns with Temp as lookup.
5. You will get the output as desired.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is a merge?
What is the difference between orabulk and bcp stages?
What is the use of hoursfromtime() function in transformer stage in datastage?
Name the command line functions to import and export the DS jobs?
How to find value from a column in a dataset?
how to delete one row in target dataset
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Which commands are used to import and export the datastage jobs?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What are orabulk and bcp stages?
How do y read Sequential file from job control?
What are iconv and oconv?
what are the devoleper roles in real time? plz tell i am new to datastage....
On which interface you will be working as a developer?
How to RD using transformer?
