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 / sekhar
Use Full outer join and propagate left and right links into transformer.If records are not matched nulls will be populated.Identify nulls in both left and right links you will get two target and for third target just write in Contraints-isnotnull(leftlink and rightlink)-Target 2
-Isnull(leftlink.Inputcolumn)-Target1
-Isnull(Rightlink.Inputcolumn)-Target3
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the various kinds of containers available in datastage?
How many Key we can define in remove duplicate stage?
what is the use of skid in reporting?
What is difference between server jobs & parallel jobs?
What is a quality stage in datastage tool?
How to perform incremental load in datastage?
EXPLAIN SCD
What are system variables and sequencers in datastage
What is the difference between informatica and datastage?
How many areas for files does datastage have?
What is a merge?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What are routines in datastage? Enlist various types of routines.