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 / 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
project Steps,hits, Project level HArd things,Solved methods?
If you want to use the same piece of code in different jobs, how will you achieve it?
On which Dimension Table you implemented SCD Type in your Project
What is the difference between datastage and informatica?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What are stage variables?
What is merge stage?
what is the use of materialized view?
What is a datastage job?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is use Array size in datastage
what are the devoleper roles in real time? plz tell i am new to datastage....
Why do you need stage variables?
Define project in datastage?
Explain the datastage parallel extender (px) or enterprise edition (ee)?