Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 5643 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / subhash
SeqFile1----->|
.................|ChangeCapture--->Transformer--->TGT
SeqFile2----->|
SeqFile1 & SeqFile2 are the inputs to Change Capture.
From the output Change Capture Stage we one extra column
‘Change Code’.
If, the record is same in both file, i.e. Copy Record.
Change Code=0
If, the record is only in SeqFile1, i.e. insert Record.
Change Code=1
If, the record is only in SeqFile2, i.e. delete Record.
Change Code=2
If, the record is in both files but with some modifications,
i.e. edit/update Record. Change Code=3
If all Change are '0' then 2 files having same Data.
In the transformer constraints, we can mention as ‘ change
code <>0’ then set ‘Abort After Rows’ to ‘1’.
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What is the difference between hashfile and sequential file?
What is quality stage?
Why do we use link partitioner and link collector in datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
What is the difference between informatica and datastage?
Lookup constraints
What is the command line function to import and export the ds jobs?
What is size of a transaction and an array means in a datastage?
Is it possible to query a hash file?
Is the value of staging variable stored temporarily or permanently?
Define Merge?
describe the Steps to confiure a Qlogic switch
What is the flow of loading data into fact & dimensional tables?
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 functionalities of link collector?
