Answer Posted / 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

What is the different type of jobs in datastage?

1030

---

What is the precedence of stage variables,derivations, and constraints?

1126

---

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?

2285

---

Can you explain tagbatch restructure operator?

1215

---

What is data partitioning?

1268

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2160

---

options available in sequence job to run,validate?

1363

---

Can you explain kafka connector?

1378

---

How to clean the datastage repository?

1181

---

Name the different sorting methods in datastage.

1100

---

How can we improve the performance in datastage?

1146

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3181

---

Give an idea of system variables.

1090

---

Explain the importance of surrogate key in data warehousing?

1233

---

Is possible to create skid in dim,fact tables?

2691

---