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.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.