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
- 7279 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
Triggers,VIEW,Procedures
What is difference between symmetric multiprocessing and massive parallel processing?
How to implement complex jobs in data stage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are stage variables and constants?
What are the different types of lookups in datastage?
What are the steps needed to create a simple basic datastage job?
What are the enhancements made in datastage 7.5 compare with 7.0?
What are data elements?
Define orabulk and bcp stages?
What are the areas of application?
What is "fatal error/rdbms code 3996" error?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Where the datastage stored his repository?
AGGREGATOR default datatype
