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
- 14217 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
How do you generate sequence number in datastage?
What are the various kinds of containers available in datastage?
Distinguish between informatica & datastage. Which one would you choose and why?
What are transforms and what is the differenece between routines and transforms?
how do u catch bad rows from OCI stage? And what CLI stands for?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
what is use of SDR function?
how to implement scd2 in datastage 7.5 with lookup stage
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is process model?
How many types of hash files are there?
How to manage date conversion in Datastage?
Does datastage support slowly changing dimensions ?
How do you import and export the datastage jobs?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
