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
- 5554 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 operational data stage (ods) and data warehouse?
What are datastage sequences?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
How do you import and export data into datastage?
How do you reject records in a transformer?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Is the value of staging variable stored temporarily or permanently?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Can you explain repository tables in datastage?
What is job control?
What is the difference between hashfile and sequential file?
How do y read Sequential file from job control?
What is staging variable?
How do you register plug-ins?
how can we create rank using datastage?what is the meaning of rank?
