Answer / saikiran katari

using BATCH ID or ROW ID or VERSION ID WE CAN SOLVE THIS PROBLEM..

Answer / murali

By using CDC stage ..provide before and after datasets to CDC through CDC stage u get change code =3 then you can get updated records

Answer / varma

As a developer you cannot find it unless you have CREATE_TS column in the table. Its always a best practice to have this column which records timestamp.

DBAs can find out in several ways (Tracing etc) but its not a straight forward way

Answer / ranjit reddy a

by using scd1,scd2

Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?

2 Answers  

---

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

1 Answers  

---

How many number of reject links merge stage can have?

7 Answers   TCS,

---

What is the use of datastage director?

1 Answers  

---

I have a few records all are same structures data, I want to store data in multiple targets how?

4 Answers   Polaris,

---

What are the features of datastage flow designer?

1 Answers  

---

What is container and then types?

1 Answers  

---

how to configure databases through datastage

2 Answers  

---

when u face critical situation in ur project, how to solve them?

1 Answers   Toyota,

---

What are the functionalities of link collector?

1 Answers  

---

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers  

---

How do u view log file for a particular job?

6 Answers   HP,

---