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
- 8252 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
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 do u catch bad rows from OCI stage? And what CLI stands for?
Where the datastage stored his repository?
How you Implemented SCD Type 1 & Type 2 in your project?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What are the functionalities of link partitioner?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are some prerequisites for datastage?
How do you schedule or monitoring the job?
What are the components of ascential data stage?
What is "fatal error/rdbms code 3996" error?
Explain connectivity between datastage with datasources?
What is ibm datastage?
Differentiate between datastage and datastage tx?
How do u convert the columns to rows in datastage?
