Answer / 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 steps should be taken to improve Datastage jobs?

0 Answers  

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

0 Answers   Syntel,

---

how to call routines in stages?

3 Answers   ME,

---

How do you reject records in a transformer?

0 Answers  

---

I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

2 Answers  

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

0 Answers  

---

What is the use of hoursfromtime() function in transformer stage in datastage?

0 Answers  

---

Unix command to view the data in a dataset

2 Answers   IBM,

---

Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers   CGI,

---

In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.

1 Answers   IBM,

---

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...

5 Answers  

---

what is set mapping in datastage??

2 Answers   ADP,

---