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
- 13645 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
What is the difference between hashfile and sequential file?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What are the types of containers?
What is merge stage?
what is the use of surogate key in datastage
options available in sequence job to run,validate?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How do u convert the columns to rows in datastage?
Define ds designer?
What is a merge?
What are the partitioning techniques available in link partitioner?
How a server job can be converted to a parallel job?
what is ds administrator used for?
How many types of hash files are there?
What is ibm datastage?
