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 / rahul verma

We need to compare the two source data using Change Data
Capture stage. If the Change_code is '0' then there are no
differences between the two sources. If the value of
Change_code is "1" or "2" or "3" then all the data in two
sources are not same.
To abort the job in case of any discrepancies between two
sources, we can make use of a Transformer stage wherein we
can provide the condition for CHange_code <>0, this will
pass the unmatched record to next stage.Since we need to
abort the job, in the same transformer derivation - check
the abort box and mention row = 1, which will result in as
soon as any unmatched record leaves this transfomer stage,
the job aborts. Hence serve the purpose.

Kindly comment on my resolution and pls correct me in case
i am wrong.

Is This Answer Correct ?    9 Yes 1 No

Post New Answer

More Data Stage Interview Questions

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

0 Answers  


What is the precedence of stage variables,derivations, and constraints?

0 Answers  


SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

1 Answers   TCS,


can explain wt is the pool for file.

1 Answers   CTS,


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

0 Answers  






there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers   Virtusa,


what are .ctl(control files) files ? how the dataset stage have better performance by this files?

0 Answers   IBM,


whats relation between configuration file and datasets?

2 Answers   L&T, Wipro,


How to convert table data into xml file using xml output stage? please explain step by step;

2 Answers   IBM,


in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?

0 Answers   IBM,


how will u design file watch jobs?

2 Answers  


How a server job can be converted to a parallel job?

0 Answers  


Categories