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
- 13520 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
Why do we use exception activity in Datastage?
What is the difference between account and directory options ?
Explain the situation where you have applied SCD in your project?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Can you explain tagbatch restructure operator?
Define orabulk and bcp stages?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How one source columns or rows to be loaded in to two different tables?
What can we do with datastage director?
How to read multiple files using a single datastage job if files have the same metadata?
What are datastage sequences?
What are the components of ascential data stage?
In Datastage, how you can fix the truncated data error?
What are the different kinds of views available in a datastage director?
What are the processing stages?
