Interested to Buy Any Domain ? << Click Here >> for more details...
I have 2 Files like
fileA fileB Output1 Output2 Output3
1 6 1 6 11
2 7 2 7 12
3 8 3 8 13
4 9 4 9 14
5 10 5 10 15
6 11
7 12
8 13
9 14
10 15
please let know
- 6 Answers
- 9876 Views
- I also Faced
- E-Mail Answers
Answer Posted / mohit
We can solve this by using Change capture stage. First,we
use source as 'A' and refrerence as 'B' both of them are
connected to Change capture stage. From, change capture
stage it connected to filter stage and then targets X,Y and
Z.
(Change Code '0'--->exist in both, copy record
Change Code '1'--->Exists in SRC 'A', INSERT record
Change Code '2'--->Exists in SRC 'B', DELETE record
Change Code '3'--->Exists in 'A' & 'B' with changes, UPDATE
record)
In the filter stage:
Change_code column=1 it goes to 'X' [1,2,3,4,5]
Change_code column=0 it goes to 'Y' [6,7,8,9,10]
Change_code column=2 it goes to 'Z' [11,12,13,14,15]
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Give an idea of system variables.
Which commands are used to import and export the datastage jobs?
Define Merge?
what is ds administrator used for?
What is the sortmerge collector?
Explain Quality stage?
EXPLAIN SCD
How a routine is called in datastage job?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Can you explain link buffering?
Is possible to create skid in dim,fact tables?
How can we improve performance of data stage jobs?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How and where you used hash file?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
