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
- 13951 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
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What are the different common services in datastage?
What is meta stage?
What is the purpose of interprocessor stage in server jobs?
Can you filter data in hashed file?
What is ibm datastage?
Explain connectivity between datastage with datasources?
what is repositery?
What is the difference between passive stage and active stage?
what is the use of materialized view?
How do you start developing a datastage project?
What is the precedence of stage variables,derivations, and constraints?
Have you used Unstructured data?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Is it possible to query a hash file?
