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

What is ds designer?

762

---

What is a quality stage in datastage tool?

712

---

Have you have ever worked in unix environment and why it is useful in datastage?

778

---

What is difference between server jobs & parallel jobs?

710

---

Explain how a source file is populated?

928

---

---

How do you generate sequence number in datastage?

721

---

What are the areas of application?

778

---

EXPLAIN SCD

1043

---

Explain the situation where you have applied SCD in your project?

1661

---

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

1786

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

645

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2636

---

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

1846

---

How do you start developing a datastage project?

749

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2378

---