Answer / vinod upputuri

This is done by using the Change_Capture_Stage.

In the CDS stage: specify the change key's--> cid and
change_values as cname,add and phone etc

CDC stage triggers the Change_code as 3 if there is any
changes in the cname or add or phone no for the existing cid.

Ex: cid,cname,add,phone,email
1,'vin','bang','08979','vin@Gmail.com'

REf:
cid,cname,add,phone,email
1,'vin','HYD','08979','vin@Gmail.com'

O/P: cid,cname,add,phone,email,Change_code
1,'vin','HYD','08979','vin@Gmail.com',3

What are stage variables, derivations and constants?

0 Answers  

---

Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)

3 Answers   HSBC,

---

what r the sources u need to create the datastage?

1 Answers  

---

What is lookup table?

5 Answers  

---

Explain the situation where you have applied SCD in your project?

0 Answers  

---

How to convert alpha Numeric values to alpha using functions?

1 Answers   CTS,

---

which r the connectors used in san?

0 Answers  

---

how to load meta data

2 Answers   IBM,

---

i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com

2 Answers   Wipro,

---

Is possible to create skid in dim,fact tables?

0 Answers   NTT Data,

---

In a table 100 records are there after 50records job is aborted how can u insert all records in target table.

1 Answers   Cap Gemini,

---

I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?

1 Answers   CGI,

---