What is Slowly Changing Dimension SCD? Can you give one example?

1.	What is Slowly Changing Dimension SCD? Can you give one example?
Answer» Slowly Changing Dimensions refer to changing value of an attribute over the time. It is one of common concept in a Data Warehouse. Example Andy is an employee of XYZ Inc. He was first located in New York City in July 2015. Original entry in the Employee lookup table has the following record − Employee_IdNameLocation 10001LocationAndyLocationNew York At a later date, he has been relocated to LA, California. How should XYZ Inc. now modify its employee table to reflect this change? This is known as "Slowly Changing Dimension" concept.

Answer»

Slowly Changing Dimensions refer to changing value of an attribute over the time. It is one of common concept in a Data Warehouse.

Example

Andy is an employee of XYZ Inc. He was first located in New York City in July 2015. Original entry in the Employee lookup table has the following record −

Employee_IdNameLocation

10001LocationAndyLocationNew York

At a later date, he has been relocated to LA, California. How should XYZ Inc. now modify its employee table to reflect this change?

This is known as "Slowly Changing Dimension" concept.

Discussion

No Comment Found

Related InterviewSolutions

What are the different ways of assigning permissions to OBIEE repository?
Is it possible to create outer join in Physical layer?
When you have Tables T1 and T2 which are not joined, what will happen in BMM layer?
What is the difference between OBIEE 10g and OBIEE 11g administration?
What are different Application roles in BI system?
What is OBIEE Security? How do you define a Security policy in OBIEE system?
What do you understand by Data Level Security and Object Level Security?
What do you understand by connection pool and how many connection pools did you have in your last project?
What is the use of Column Prompts? Where they are used?
What are Inline prompts?