I have a input as:
Col
1
1
2
2
3
I want 3 output as:
Output1:
1
1
Output2:
2
2
Output3:
3
i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help
Answer Posted / vaibhav
Actually it is like:
I want as many target links as much u have types of duplicates in my input file.. Pls help guys..
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What are transforms and what is the differenece between routines and transforms?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Why do you need stage variables?
How to implement complex jobs in data stage?
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
What is the difference between in process and inter process?
What are the primary usages of datastage tool?
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
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the process of killing a job in datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is the difference between validated and compiled in the datastage?
How do you import and export data into datastage?
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.