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 / 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 |
Explain entity, attribute and relationship in datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?
What are the types of hashed files in data stage
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?
WHAT are unix quentios in datastage
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
Enlist various types of routines in datastage.
What is the purpose of pivot stage?
What all are the different way to run a job?
what is executable in DataStage?