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
- 9612 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
how do u catch bad rows from OCI stage? And what CLI stands for?
What are the job parameters?
What is the project in datastage?
What is meta stage?
Nls stands for what in datastage?
What is quality stage?
How you can fix the truncated data error in datastage?
Define data aggregation?
What are some prerequisites for datastage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
How to read the length of word in unix?
What can we do with datastage director?
Define Routines and their types?
Explain the situation where you have applied SCD in your project?
What all are the different way to run a job?
