Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 13534 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Why do we use link partitioner and link collector in datastage?
what is the use of surogate key in datastage
What is process model?
What is orabulk stage?
Is it possible to query a hash file?
Explain the situation where you have applied SCD in your project?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Difference between sequential file and data set?
If you want to use a same piece of code in different jobs, how will you achieve this?
How one source columns or rows to be loaded in to two different tables?
What are the important features of datastage?
What is the difference between informatica and datastage?
What are the difference types of stages?
