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
- 7577 Views
- I also Faced
- E-Mail Answers
Answer Posted / upputuri.vinod
I am going to explain with example.
A B T1 T2
1 1 2 7
2 7-----> Now according to the QA in 3 9
3 9 4 5.
4 5
i am going to use the lookup stage..
1-------LK2<----B
! !
! !
T2 A---->LK1------1
T1
here T1 is the rejected data from LK1 where T2 rejected data
from LK2.
The condition in LK is Reject.
I hope U got the point..
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What is the precedence of stage variables,derivations, and constraints?
root tree will find which is server job and which is parallel job?
Differentiate between data file and descriptor file?
whom do you report?
What are the features of datastage flow designer?
options available in sequence job to run,validate?
What is job control?
Distinguish between informatica & datastage. Which one would you choose and why?
What is the difference between account and directory options ?
Can we use target hash file as a lookup ?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What are the different plug-ins stages used in your projects?
How you can fix the truncated data error in datastage?
What is the difference between odbc and drs stage?
How and where you used hash file?
