Answer / sindhu

type 1 can be implemented using change capture and change apply stage with sequential files

Answer / ashutosh g

Hi,
SCD means Slowly Changing Dimensions.
There are multiple ways to solve this. However, here are
the three main types:

Type1 : The new record replaces the original record. No
trace of the old record exists.

Type2 : A new record is added into the customer dimension
table with an Active flag or something. Therefore, the
customer is treated essentially as two people. This is the
most popular method.

Type3 : The original record is modified to reflect the
change. Essentially, this method requires adding a new
column to reflect the change. This is very seldom used.

source-->LookupTransform---->transform--->Target DIm
|
Hashfile

explain unit testing,systemtesting,integrated testing

1 Answers   CSC,

---

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,

---

on how many columns we can perform aggregation in the Aggregator stage?

3 Answers   Reliance,

---

what is mapping lookup

1 Answers  

---

what is materialized view used datastage?

1 Answers   HSBC,

---

How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?

1 Answers   IBM,

---

Differentiate between Join, Merge and Lookup stage?

0 Answers  

---

How many Key we can define in remove duplicate stage?

0 Answers   CTS,

---

Hai..,in datastage how to explain project in interview?please explain any domain please.

1 Answers   Wipro,

---

What are the steps needed to create a simple basic datastage job?

0 Answers  

---

How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?

3 Answers  

---

What all are the different way to run a job?

0 Answers  

---