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.

What are the steps required to kill the job in Datastage?

0 Answers  

---

How To find the location of APT_confid file

2 Answers   CTS,

---

what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

1 Answers   Wipro,

---

in aggregator , how can i get the sum in readable format

4 Answers   IBM,

---

by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?

1 Answers  

---

i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers   IBM,

---

what is the difference between the join and look up explin me one exmple

3 Answers  

---

Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.

1 Answers   IBM,

---

Can we use target hash file as a lookup ?

0 Answers  

---

What is exact difference between Parallel Jobs and server Jobs..

7 Answers   IBM,

---

HOW CAN WE SEE THE DATA IN DATASET?

4 Answers  

---

How do you load dimension data and fact data? Which is first

2 Answers  

---