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 a merge in datastage?

770

---

How can we improve performance of data stage jobs?

614

---

To see hidden files in LINIX?

944

---

Where do you see different stages in the designer?

630

---

What is "fatal error/rdbms code 3996" error?

663

---

---

How to find value from a column in a dataset?

1767

---

Why do you need stage variables?

662

---

Is it possible to query a hash file?

1565

---

What are the benefits of datastage?

723

---

What is the use of datastage designer?

638

---

What could be a data source system?

577

---

Define orabulk and bcp stages?

682

---

How rejected rows are managed in datastage?

921

---

Differentiate between odbc and drs stage?

593

---

Can you explain players in datastage?

705

---