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 / shar

ok
Follow this:

seqStg1,seqStg2-->Funnel-->Filter-->seq1,seq2,seq3.

Since we have less data to sort and to remove duplicates use
hash partition and unique option at input link.

Thats it.

I wonder why such a goofy question asked by capegemini?

Is This Answer Correct ?    9 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does datastage support slowly changing dimensions ?

659


What is quality stage?

570


What are the different options associated with dsjob command?

937


Define project in datastage?

660


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

1779






What is difference between join, merge and lookup stage?

634


To see hidden files in LINIX?

941


What are stage variables, derivations and constants?

669


im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

1627


Name the third party tools that can be used in datastage?

611


What is staging variable?

622


What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2541


Can you implement SCD2 using join, transformer and funnel stage?

1082


Where do you see different stages in the designer?

628


Difference between data warehousing and olap?

650