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
- 5508 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
Can you explain engine tier in information server?
How to Remove Duplicate using SQL?
What are the processing stages?
Differentiate between odbc and drs stage?
Can you explain link buffering?
What are the job parameters?
What is the importance of the exception activity in datastage?
What are the important features of datastage?
CHANGE CAPTURE
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Why we use surrogate key?
What are the types of containers and how to create them?
Can you explain repository tables in datastage?
What is the difference between datastage and informatica?
Demonstrate experience in maintaining quality process standards?
