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
- 7188 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 stage variables?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
State the difference between an operational datastage and a data warehouse?
What are the different plug-ins stages used in your projects?
What is orabulk stage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
describe the Steps to confiure a Qlogic switch
what is the difference between == and eq in UNIX shell scripting?
Describe link sort?
How the ipc stage work?
Nls stands for what in datastage?
How to manage date conversion in Datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is a datastage job?
