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
- 13897 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
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
How one source columns or rows to be loaded in to two different tables?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is the purpose of interprocessor stage in server jobs?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Could anyone give brief explanation bout datastage admin
Is the value of staging variable stored temporarily or permanently?
What are the processing stages?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are the types of containers and how to create them?
What are orabulk and bcp stages?
What are the stages in datastage?
How do y read Sequential file from job control?
What are the components of ascential data stage?
