file1
1
2
3
4
file2
3
4
5
6

output should be in three targets
T1 T2 T3
1 3 5
2 4 6

how to do this? can any one help?

Thanks

Answer Posted / yuvraj

This can be done using change capture stage:

Seq1,Seq2 ----> change capture (here keep Drop Output for
copy : False) ---> Filter ----> seq1,seq2,seq3

from this above output will get

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

374


what is the difference between == and eq in UNIX shell scripting?

985


In Datastage, how you can fix the truncated data error?

653


Describe link sort?

663


What is orabulk stage?

650






Demonstrate experience in maintaining quality process standards?

1957


Can you highlight the main features of ibm infosphere information server?

646


Which commands are used to import and export the datastage jobs?

992


Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

1770


What is datastage?

656


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3280


EXPLAIN SCD

977


Describe stream connector?

840


How to clean the datastage repository?

708


How to reverse the string using SQL?

907