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
- 6507 Views
- IBM, I also Faced
- E-Mail Answers
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 |
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
What is Horizontal transformation, vertical transformation,diagonal transformation?
How to remove duplicates in transformer stage? in parallel mode
How many jobs in ur project? Explain any complex job u have done in ur project?
In which situations we can use normal and sparse lookup stages
What a datastage macro?
How many types of sorting methods are available in datastage?
1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran
What is audit table?
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,
How you can fix the truncated data error in datastage?
What are the features of datastage flow designer?
Teradata 
