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
- 9447 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
Where do the datastage jobs get stored?
How do you schedule or monitoring the job?
Why do you need stage variables?
How to read the length of word in unix?
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 ?
Is possible to create skid in dim,fact tables?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Terminate Activity
Highlight the main features of datastage?
Differentiate between operational datastage (ods) and data warehouse?
Have you used Unstructured data?
which r the connectors used in san?
how do u catch bad rows from OCI stage? And what CLI stands for?
how to delete one row in target dataset
How many Key we can define in remove duplicate stage?
