Answer / pooja

Let me just elaborate the earlier answer clearly.

1. Two input datasets are required for change data caputure
stage.
One is Old dataset
Second is New or updated dataset

2. Give in the 2 inputs to the change capture stage and the
target as a dataset.

3. Let the incoming data be sorted based on a key column(s)
for performance purpose in the change Caputure stage.

4. Upon executing the job, the data when viewed from the
dataset shows a new column added apart from the output
data. A change code column would be generated in the change
capture stage having values as 0, 1, 2, 3 which depicts the
changes on comparing the 2 input datasets such as copy(0),
Insert(1), Delete(2), Edit(3).

5. See what kind of data you need in the output target like
copy, insert, delete, edit.

6. To apply SCD Type 2 we require Start date and End date
columns.

7. The Change Capture Stage output is given to a
Transformer Stage, where 2 new columns are generated with
Effective Start Date and End Date.

8. If you need all Inserted or new data to be passed in to
a particular dataset then you need to specify an
appropriate condition in the Transformer Stage to the
outgoing link. Ex. Drop Output For insert=true

9. In the similar way other data can also be captured or a
Filter can also be used after the Transformer Stage to
filter the data into the targets based on the requirement.

Answer / nidhi

1.for change capture stafe u need two input dataset one is
old one & second is the new or updated one.
2. incoming data should be sorted.
3. allow what kind of u need to check like new , delete,
change,copy.
4. if u wanna all new data should be passed to the outgoing
link then u need to specify Drop Output For insert=true.
5.there should be a change key or change key value, on the
basis of key data will be chaecked.
thanks

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers   Infosys,

---

What is a datastage job?

0 Answers  

---

whats relation between configuration file and datasets?

2 Answers   L&T, Wipro,

---

How do u call shellscript/Batch file from DS?

4 Answers   HP,

---

What is Fastly Changing Dimension?

6 Answers   TCS,

---

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

2 Answers   Wipro,

---

Hi Vijay here For Four CPU's how many nodes will required?

4 Answers   TCS,

---

what is the differeces between hash and modulus partition methods

4 Answers   TCS,

---

Explain the scenarios where sequential file stage runs in parallel?

3 Answers   Accenture,

---

how many types of sorting the data in data stage?

1 Answers   BoA, IBM,

---

how to run jon in unix back round process what is command use in runing a job?

2 Answers   HSBC,

---

What are the partitioning techniques available in link partitioner?

0 Answers  

---