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..

how to add a new records into source?

2000

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2179

---

What are the processing stages?

1104

---

What are the some differences between 7.x and 8.x version of datastage?

1257

---

Which warehouse using in your datawarehouse

2188

---

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1508

---

What is orabulk stage?

1048

---

What are stage variables and constants?

1150

---

How can one find bugs in job sequence?

1418

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2616

---

How to reverse the string using unix?

3515

---

How to convert RGB Value to Hexadecimal values in datastage?

4000

---

What is the differentiate between data file and descriptor file?

1364

---

What is difference between server jobs & parallel jobs?

1039

---

How we can covert server job to a parallel job?

1150

---