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 / chandra swain(hara)
mapping for above job
fileA---->joinstage---->transformer------->dataset1
^ ------>dataset2
|
|
fileB
go to joinstage ,take type of join is fullouter join,
then copy the i/p column to o/p link ,goto transformer stage
u 'll found 2 constraint tab ,in 1st constraint tab write
leftRec_column<>rightRec_column And LeftRec_column<>0,
similarly in 2nd constraint tab write
leftRec_column<>rightRec_column And RIGHTRec_column<>0
then copy only LeftRec_column to dataset1
and copy only RightRec_column to dataset2
i think u definitly get the correct answer
Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What are the types of containers?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How to Remove Duplicate using SQL?
What are the types of jobs we have in datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How a server job can be converted to a parallel job?
table actions available in oracle connector?
What can we do with datastage director?
Differentiate between Join, Merge and Lookup stage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are the functionalities of link partitioner?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
EXPLAIN SCD
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys