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
- 7598 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
Highlight the main features of datastage?
Can we use target hash file as a lookup ?
What are some different alternative commands associated with "dsjob"?
Differentiate between odbc and drs stage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What is the command line function to import and export the ds jobs?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Where the datastage stored his repository?
Can you implement SCD2 using join, transformer and funnel stage?
What are the types of containers?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
How many types of stage?
What are constraints and derivations?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What is staging variable?
