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
- 5552 Views
- IBM, I also Faced
- E-Mail Answers
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 |
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
how can find maximum salary by using Remove duplicate stage?
In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.
What are iconv and oconv?
How do you load dimension data and fact data? Which is first
how to delete one row in target dataset
What are the environmental settings for data stage,while working on parellel jobs?
how to define satge variables in transformer stage
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
explain unit testing,systemtesting,integrated testing
what is sparse lookup?
where the log files or tables can store in DS?
Teradata 
