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
- 8572 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
Why fact table is in normal form?
Name the command line functions to import and export the DS jobs?
What is the importance of the exception activity in datastage?
describe the Steps to confiure a Qlogic switch
What are the components of datastage?
What is active and passive stage?
Can you explain repository tables in datastage?
Name the different types of Lookups in Datastage?
Explain how a source file is populated?
How will you move hashed file from one location to another location?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Where the datastage stored his repository?
Describe stream connector?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
