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 / prabhu rathnam
Seq1,Seq2--->join--->removeduplicate---->filter--->trg1,trg2,trg3
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Differentiate between validated and Compiled in the Datastage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Lookup constraints
what is the use of surogate key in datastage
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is the difference between datastage and informatica?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Can you explain repository tables in datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Can you filter data in hashed file?
What are the different layers in the information server architecture?
How can one find bugs in job sequence?
how to abort the job its matain duplicates?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?