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
- 7487 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 should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are the various kinds of the hash file?
what is use of SDR function?
What is data partitioning?
How to read the length of word in unix?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
How do you generate sequence number in datastage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
table actions available in oracle connector?
Is possible to create skid in dim,fact tables?
What is difference between join, merge and lookup stage?
What are orabulk and bcp stages?
how to implement scd2 in datastage 7.5 with lookup stage
why do u need the IOS upgradation in a FC switch
On which Dimension Table you implemented SCD Type in your Project
