Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9 Answers
- 14193 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
Hi, if you know the number of duplicates coming your from source then it's easy to move the duplicates to the defined target using router transformation easily,
But if you do not know the number of duplicates then first you must sort the data on the value of duplicate column and then using Transaction Component as available in informatica you can create n no of targets depending upon the values encountered.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
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 merge stage?
What is a folder? Difference types of stages?
client know skid info?
Can you filter data in hashed file?
What are stage variables, derivations and constants?
How do you import and export data into datastage?
CHANGE CAPTURE
How one source columns or rows to be loaded in to two different tables?
How many types of views are there in a datastage director?
What are the different type of jobs in datastage?
Can you explain repository tables in datastage?
What is the difference between Datastage 7.5 and 7.0?
How many Key we can define in remove duplicate stage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
