What Are Slowly Changing Dimensions? Why We Are Used Scd?

1.	What Are Slowly Changing Dimensions? Why We Are Used Scd?
Answer» Slowly Changing Dimensions are those whose DATA are not fixed. SCD types: SCD type 1: Whose data is not fixed. Historical data are not saved. Data keeps on changing.-> Current Data SCD type 2: Whose data is fixed and ALSO save historical data. SCD type 3: Like SCD type 2 only but save historical data in ANOTHER table. In one table data will updated and in another table historical data will be there. Slowly Changing Dimensions are those whose data are not fixed. SCD types: SCD type 1: Whose data is not fixed. Historical data are not saved. Data keeps on changing.-> Current Data SCD type 2: Whose data is fixed and also save historical data. SCD type 3: Like SCD type 2 only but save historical data in another table. In one table data will updated and in another table historical data will be there.

Answer»

Slowly Changing Dimensions are those whose DATA are not fixed.

SCD types:
SCD type 1: Whose data is not fixed.
Historical data are not saved. Data keeps on changing.-> Current Data

SCD type 2: Whose data is fixed and ALSO save historical data.

SCD type 3: Like SCD type 2 only but save historical data in ANOTHER table. In one table data will updated and in another table historical data will be there.

Slowly Changing Dimensions are those whose data are not fixed.

SCD types:
SCD type 1: Whose data is not fixed.
Historical data are not saved. Data keeps on changing.-> Current Data

SCD type 2: Whose data is fixed and also save historical data.

SCD type 3: Like SCD type 2 only but save historical data in another table. In one table data will updated and in another table historical data will be there.

Discussion

No Comment Found

Related InterviewSolutions

How You Provide Security To Reports? How You Provide Security To Packages ?
Can Reportnet Supports Cubes?
What Are The Migration Tools Available In The Market With Respect To Cognos Such As Impromptu Reports Are Migrated To Cognos Reportnet?
What Is The Difference Between List Report And Crosstab Report?
How To Create Measures And Dimensions?
How You Burst The Reports? If You Are Bursted Reports Is Not Reached To Destination How You Identify?when You Import Data Into Catalog You Have Complex Columns Names. How Do You Change The Name Of Those Columns?
How To Create Cubes In Transformer ?
What Is Model And How To Create Model And How To Test Model?
Where You Can Save The Report Net Documentation In Our Local System?
How Many Levels Can Be Used In Drill Through Reports?