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?



if we using two sources having same meta data and how to check the data in two sources is same or ..

Answer / 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

More Data Stage Interview Questions

how to remove duplicates in transformer stage by using stage variables?one example?

6 Answers   Syntel, TCS,


How to find value from a column in a dataset?

0 Answers   TIAA CREF,


How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?

5 Answers   TCS,


I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

3 Answers   Virtusa,


Define meta stage?

0 Answers  






Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?

2 Answers   TCS,


Which commands are used to import and export the datastage jobs?

0 Answers  


What are the main differences you have observed between 7.x and 8.x version of datastage?

0 Answers  


How and where you used hash file?

0 Answers  


can explain wt is the pool for file.

1 Answers   CTS,


Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,

3 Answers   TCS,


Explain connectivity between datastage with datasources?

0 Answers  


Categories