Answer / subhash

SeqFile1----->|
.................|ChangeCapture--->Transformer--->TGT
SeqFile2----->|

SeqFile1 & SeqFile2 are the inputs to Change Capture.
From the output Change Capture Stage we one extra column
‘Change Code’.
If, the record is same in both file, i.e. Copy Record.
Change Code=0
If, the record is only in SeqFile1, i.e. insert Record.
Change Code=1
If, the record is only in SeqFile2, i.e. delete Record.
Change Code=2
If, the record is in both files but with some modifications,
i.e. edit/update Record. Change Code=3

If all Change are '0' then 2 files having same Data.

In the transformer constraints, we can mention as ‘ change
code <>0’ then set ‘Abort After Rows’ to ‘1’.

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

0 Answers   ABC, TCS,

---

HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?

1 Answers   IBM,

---

Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers   Accenture,

---

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

2 Answers  

---

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

0 Answers   Alpharithm Technologies,

---

Define Data Stage?

0 Answers  

---

how to identifie,is it innerjoin,leftouter join in lookup?

2 Answers   Hexaware,

---

How to enter a log in auditing table whenever a job get finished?

2 Answers   L&T,

---

Explain usage analysis in datastage?

0 Answers  

---

convert yyyy mm dd to dd mm yyyy?

4 Answers  

---

How to Convert a string function to date function by using only sequential file stage with out using other stages ?

5 Answers   TCS,

---

what is .dsx files

3 Answers   IBM,

---