I am having the 2 source files A and B and I want to get the
output as, the data which is in file A and which doesn't in
file B to a target 1 and which is in file B and which doesn't
in file A to a target 2?
- 3 Answers
- 6517 Views
- I also Faced
- E-Mail Answers
Answer Posted / reddymkl.dwh
FullOuter
FileA------->Join--------->Filter-------->T1
| |
| |
| |
| |
FileB T2
Use Fullouter Join Then
Filter-------> Where =Right.link=''
Where =Left.link=''
Nothing but A-B, B-A scenario.
Plz correct me if am wrong.....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Describe link sort?
What are orabulk and bcp stages?
What is the use of datastage director?
How to manage date conversion in Datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What are the various kinds of containers available in datastage?
Explain the importance of surrogate key in data warehousing?
Name the different types of Lookups in Datastage?
What steps should be taken to improve Datastage jobs?
Where do the datastage jobs get stored?
Why we use surrogate key?
What are the different kinds of views available in a datastage director?
What are datastage sequences?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is the precedence of stage variables,derivations, and constraints?
