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
- 5573 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
Name the different types of Lookups in Datastage?
How do y read Sequential file from job control?
What is a ds designer?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are the some differences between 7.x and 8.x version of datastage?
What are the functionalities of link partitioner?
What is the difference between Datastage 7.5 and 7.0?
Is it possible to query a hash file?
CHANGE CAPTURE
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Can you explain players in datastage?
Describe the main features of datastage?
