Answer Posted / pranay

scd2: slowly changing dimension 2

SCD2 is used to maintain both current data and historical
data.
for ex: If we are having following data
cid cname city country
101 raju hyderabad India

if we want to implement scd2 for the above data we need to
create target table with columns

scid cname city country flag version date
scid - surrogate key column

and if the customer moves from hyderabad to delhi then the
output will be

scid cname city country flag version
1 raju hyderabad India 0 1
2 raju delhi India 1 2

Flag = 0 defines historical data
Flag = 1 defines current data

Similarly if again raju moves from delhi to mumbai the the
output will be

scid cname city country flag version
1 raju hyderabad India 0 1
2 raju delhi India 0 2
2 raju mumbai India 1 3
n so on..

What is usage analysis in datastage?

829

---

Does datastage support slowly changing dimensions ?

667

---

CHANGE CAPTURE

902

---

What are the different options associated with dsjob command?

949

---

How you Implemented SCD Type 1 & Type 2 in your project?

3701

---

---

What is merge stage?

775

---

What is a merge in datastage?

780

---

Which warehouse using in your datawarehouse

1688

---

What are the areas of application?

671

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2088

---

What are transforms and what is the differenece between routines and transforms?

625

---

How do you reject records in a transformer?

637

---

Differentiate between datastage and informatica?

733

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3389

---

What is difference between symmetric multiprocessing and massive parallel processing?

664

---