Type 1 and Type 2 dimension in the same table


  • Assuming a table with both Type 1 and Type 2 dimensions how do you engineer an ETL load?

    Please correct my options below if I am wrong

    Option 1: Inside a Slowly changing dimension set all 3, fixed attributes, Historical attributes and changing attributes. Since historical attributes is Type 2 and changing attributes is Type 1. We get what we want, Correct?

    Option 2: writing a merge statement, but not sure how exactly i would be code that.

    Please suggest a way if you think both the options are wrong. Thanks in advance.


    Friday, April 11, 2014 9:41 PM