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
which r the connectors used in san?
What are transforms and what is the differenece between routines and transforms?
Notification Activity
What is the difference between hashfile and sequential file?
What is the purpose of pivot stage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How do you register plug-ins?
What is data partitioning?
What is difference between join, merge and lookup stage?
What all are the different way to run a job?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Where do the datastage jobs get stored?
What are system variables and sequencers in datastage
What are the areas of application?
What are the some differences between 7.x and 8.x version of datastage?