Slowly Changing Dimensions (SCD) SSIS

Refer Source Video:

Slowly Changing Dimensions (SCD) SSIS


Employee

dimEmployee  ( here "Inferred"column  defined as "BIT"  0  or  1(refered ad Inferred)

Fact

note: 

"Inferred"-  there is an earlier arriving Fact data.

i.In the fact table ,one can not enter as it references the FK , which is the PK in dimension table.
ii.so in Employee table there is no entry yet, the "employeeID" , defined as "Business Key"
iii.but to make the record go through in the "dimEmployee" enter  using 

sql Insert statement a record,  having values and  Insert Into dimEmployee values 
having "Inferred" value as 1.

Run the Package:
it creates the update,Insert statements.

After the Employee details comes then again running SSIS package inserts all other details to "dimEmployee"
removes the "Inferred" 1 to 0.
---
OLEDB Datasource

Slowly changing Dimension

---
Configuring Slowly Changing Dimension -

-"Business Key"  (i.e Surrogate Key for the table)

    note:Identity column   as  PK
    note1:natural key not mentioned here ( which is the info from source -in where it uniquely identifies  the rec

-Attributes  - Changing Attribute ( change the attribute value)
-Attribute    -Historical Attribute ( keep the value of the old that and phase out with "Start Date" or "End Date")

-Define "Inferred" as  the column