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
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 are the difference types of stages?
How many areas for files does datastage have?
How do you remove duplicate values in datastage?
What all the types of jobs you developed?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What is ds designer?
how to sort two columns in single job in datastage.
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What is job control?
What is "fatal error/rdbms code 3996" error?
What are the benefits of datastage?
How do you schedule or monitoring the job?
How do you reject records in a transformer?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What are the differences between datastage and informatica?