Demonstrate your understanding of SCD Type 1/2 Make some changes to the Excel file and to the
Fantastic news! We've Found the answer you've been seeking!
Question:
- Demonstrate your understanding of SCD Type 1/2
- Make some changes to the Excel file and to the SCD Types in the Dimension Lookup step. Try mixing SCD type1 and 2 for various columns to as to learn how it impacts the target dimension table.
- Create an expected result set manually in Excel and explain the reason briefly.
- Execute the ETL and compare the result with your own expected result set
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: