Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
- 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
Step by Step Solution
★★★★★
3.43 Rating (150 Votes )
There are 3 Steps involved in it
Step: 1
Solution I understand that SCD Type 1 and Type 2 are methods of handling changes in dimension attrib...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Income Tax Fundamentals 2013
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
31st Edition
1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516
