Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7575 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
Can you explain engine tier in information server?
what is use of SDR function?
Explain datastage architecture?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What is a ds designer?
Can we use target hash file as a lookup ?
how to sort two columns in single job in datastage.
What are the partitioning techniques available in link partitioner?
How to manage date conversion in Datastage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Define repository tables in datastage?
What are the types of containers?
which r the connectors used in san?
What is the purpose of interprocessor stage in server jobs?
Define Routines and their types?
