Answer Posted / 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

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3650

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1555

---

How can you write parallel routines in datastage PX?

1015

---

What are the types of containers and how to create them?

980

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3759

---

sed,awk,head

1468

---

What is merge stage?

1318

---

What are the types of jobs we have in datastage?

1075

---

How to clean the datastage repository?

1127

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3167

---

What is the command line function to import and export the ds jobs?

1153

---

explain about citrix scheduling tool in datastage

2458

---

How do you import and export the datastage jobs?

1161

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2064

---

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

3797

---