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
- 5483 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 flow of project?
Define Routines and their types?
what is the use of skid in reporting?
On which interface you will be working as a developer?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are the some differences between 7.x and 8.x version of datastage?
Why do we use link partitioner and link collector in datastage?
What is the method of removing duplicates, without the remove duplicate stage?
What are the processing stages?
What is ibm datastage?
What is the use of datastage director?
How to manage date conversion in Datastage?
options available in sequence job to run,validate?
Does datastage support slowly changing dimensions ?
