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
- 13935 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
Highlight the main features of datastage?
why do u need the IOS upgradation in a FC switch
What all the types of jobs you developed?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What are the different layers in the information server architecture?
How and where you used hash file?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is ds designer?
What are the areas of application?
What is the difference between datastage and datastage tx?
Is the value of staging variable stored temporarily or permanently?
What are the some differences between 7.x and 8.x version of datastage?
How the ipc stage work?
Can you implement SCD2 using join, transformer and funnel stage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
