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?
Answer Posted / 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 View All Answers
How do you start developing a datastage project?
Enlist various types of routines in datastage.
Is it possible to query a hash file?
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?
Can you implement SCD2 using join, transformer and funnel stage?
What is difference between join, merge and lookup stage?
What are the important features of datastage?
What is merge stage?
Can we use target hash file as a lookup ?
What are iconv and oconv?
How a server job can be converted to a parallel job?
What a datastage macro?
What is datastage engine?
how to export or import the jobs in .ISX file
table actions available in oracle connector?