Answer / rakesh gupta

There is not much difference between cdc stage and difference stage.Both the stage similar.

Difference between cdc stage and difference are following:-

1.In CDC stage,we should have same number of columns and same column name from both the input link.However,In difference stage we can have different number of column and Different column name.
2.The CDC stage takes two input data sets, denoted before and after, and outputs a single data set whose records represent the changes made to the before data set to obtain the after data set.However,Difference stage performs a record-by-record comparison of two input data sets, which are different versions of the same data set designated the before and after data sets. The Difference stage outputs a single data set whose records represent the difference between them.

Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises

1 Answers   TCS,

---

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,

---

6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment

3 Answers   TCS,

---

What can we do with datastage director?

0 Answers  

---

Thanks to all people who are posting their comments...

1 Answers   CTS,

---

Give an idea of system variables.

0 Answers  

---

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers   TCS,

---

In Datastage, how you can fix the truncated data error?

0 Answers  

---

What is the different type of jobs in datastage?

0 Answers  

---

j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?

1 Answers   Wipro,

---

Explain Quality stage?

0 Answers  

---

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls

7 Answers   TCS,

---