Question
Within Commongreat Finance, consider there is a customer named Ash Barty (with a surrogate key of AB1) under Super VIP customer group S1 from 1
Within Commongreat Finance, consider there is a customer named Ash Barty (with a surrogate key of AB1) under Super VIP customer group S1 from 1st June 2017, and later the customer is changed to group S2 effective from 1st July 2022 with a new a surrogate key of AB2.
Task: Based on the given information, analyse the BI system requirement of Commongreat Finance and propose type 2 and type 3 slowly changing dimension (SCD) solutions for the financial institution. You must show all the relevant tables and values. Briefly explain your SCD solutions.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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