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?
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 the Steps to confiure a Qlogic switch
how to sort two columns in single job in datastage.
What all are the different way to run a job?
Where the datastage stored his repository?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What are the functionalities of link partitioner?
How do you register plug-ins?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
How do y read Sequential file from job control?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Differentiate between hash file and sequential file?
Can you define merge?
What is size of a transaction and an array means in a datastage?
What is difference between server jobs & parallel jobs?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this