SCD Type 2

[yusra]

Hi all,

I have transformed the data into star schema and saved it in QVD, now i have to transform it into SCD Type 2.

my data includes 1 fact table and 4 dimension tables.

Fields of fact table are:

ProductID

RegionID

TimeID

SupplierID

Quantity

DefectPercentage

Dimension tables have Fields:

Table Product:

ProductID

ProductCategory

ProductName

Table Time dimension:

TimeID

Year

Month

Table Supplier Dimension:

SupplierID

SupplierName

Table Region Dimension:

RegionID

Continent

Country

Kindly help me with the script. 🙂

[Arthur_Fong]

In the table where SCD should be, add in effective date column. Link that dimension table to fact table with the original unique key and effective date column.

Eg: SCD Dimension talble key = Dimension ID + Effective Date.

       Fact Table = Dimension ID + Transaction Date.

Thanks and regards,

Arthur Fong

[Anil_Babu_Samineni]

Can't you simply load and see about star schema? PFA