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
- 7210 Views
- IBM, I also Faced
- E-Mail Answers
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
What are orabulk and bcp stages?
What are the functionalities of link partitioner and link collector?
How do u convert the columns to rows in datastage?
What is the difference between passive stage and active stage?
Can you explain kafka connector?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is the purpose of interprocessor stage in server jobs?
How do y read Sequential file from job control?
How to clean the datastage repository?
What is the difference between server job and parallel jobs?
how can we create rank using datastage?what is the meaning of rank?
How to manage date conversion in Datastage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What is use Array size in datastage
Difference between sequential file and data set?
