What Is Scd (slowly Changing Dimension)?

1.	What Is Scd (slowly Changing Dimension)?
Answer» SLOWLY CHANGING dimensions (SCD) determine how the historical changes in the dimension tables are handled. Implementing the SCD mechanism enables users to know to which category an ITEM belonged to in any given date. Slowly changing dimensions (SCD) determine how the historical changes in the dimension tables are handled. Implementing the SCD mechanism enables users to know to which category an item belonged to in any given date.

Answer»

SLOWLY CHANGING dimensions (SCD) determine how the historical changes in the dimension tables are handled. Implementing the SCD mechanism enables users to know to which category an ITEM belonged to in any given date.

Slowly changing dimensions (SCD) determine how the historical changes in the dimension tables are handled. Implementing the SCD mechanism enables users to know to which category an item belonged to in any given date.

Discussion

No Comment Found

Related InterviewSolutions

What Is Sql Server Analysis Services (ssas)?
What Is A Data Source? What Are The Different Data Sources Supported By Ssas?
What Is Impersonation? What Are The Different Impersonation Options Available In Ssas?
What Are The Difficulties Faced In Cube Development?
What Are Key, Name And Value Columns Of An Attribute?
What Is Use Of Isaggregatable Property?
How Will You Make An Attribute Not Process?
How Will You Hide An Attribute?
What Is Star, Snowflake And Star Flake Schema?
What Are The Types Of Database Schema?

What Is Scd (slowly Changing Dimension)?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment