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
- 6539 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
How a source file is populated?
What steps should be taken to improve Datastage jobs?
How do you remove duplicate values in datastage?
How to perform incremental load in datastage?
What is ibm datastage flow designer?
How rejected rows are managed in datastage?
Describe the architecture of datastage?
How do you schedule or monitoring the job?
What is difference between symmetric multiprocessing and massive parallel processing?
What are the types of jobs we have in datastage?
How to Remove Duplicate using SQL?
Differentiate between datastage and informatica?
What are orabulk and bcp stages?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
