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
- 4966 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 the difference between informatica and datastage?
Define repository tables in datastage?
How will you move hashed file from one location to another location?
what is use of SDR function?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
CHANGE CAPTURE
Can you filter data in hashed file?
Define Merge?
Define project in datastage?
What is the method of removing duplicates, without the remove duplicate stage?
Can you define merge?
How you can fix the truncated data error in datastage?
What are the some differences between 7.x and 8.x version of datastage?
What is usage analysis in datastage?
