KyaPoocha.com

Huge Collection of Interview Questions

Search our list of 7708 Interview Questions


What are slowly changing dimensions? 

Posted in Data WareHousing Interview Questions

SCD stands for Slowly changing dimensions. Slowly changing dimensions are of three types
SCD1: only maintained updated values.
Ex: a customer address modified we update existing record with new address.
SCD2: maintaining historical information and current information by using
A) Effective Date
B) Versions
C) Flags
or combination of these
scd3: by adding new columns to target table we maintain historical information and current information

Post Your Answer!
Send This to a Friend

← Why are OLTP database designs not generally a good idea for a Data Warehouse?
What are non-additive facts? →

If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!


BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |

Related Interview Questions

  • What are slowly changing dimensions ?  25.09.08

    Dimensions that change over time are called Slowly Changing Dimensions. For instance, a product price changes over time; People change their names for some reas...

  • What is rapidly changing dimension?  22.09.08

    What is rapidly changing dimension? There is no Dimension called Rapidly changing dimension in DWH. But if you consider overall ODS tables; a rapidly changing...

  • What is hybrid slowly changing dimension?  22.09.08

    Let me give an example to make the point clear.... Like account information is usually maintained in two categories: Current Account and other is Time of...

  • Explain degenerated dimension in detail ?  22.09.08

    A Degenerate dimension is a Dimension which has only a single attribute. This dimension is typically represented as a single field in a fact table. The da...

  • What is conformed fact?  20.09.08

    Conformed dimensions are the dimensions which can be used across multiple Data Marts in combination with multiple facts tables accordingly...

  • What is surrogate key ? where we use it explain with example ?  20.09.08

    surrogate key is a substitution for the natural primary key. It is just a unique identifier or number for each row that can be used for the primary key to th...

  • What is degenerate dimension table?  18.09.08

    Degenerate Dimensions : If a table contains the values, which r neither dimesion nor measures is called degenerate dimensions.Ex : invoice id,empno...

  • What is hybrid slowly changing dimension ?  18.09.08

    Hybrid SCDs are combination of both SCD 1 and SCD 2. It may happen that in a table, some columns are important and we need to track changes for them i.e capt...

  • Why aren’t my frames the exact size I specified?  11.09.08

    Older versions of Netscape Navigator seems to convert pixel-based frame dimensions to whole percentages, and to use those percentage-based dimensions when layin...

  • What are conformed dimensions?  17.03.06

    Conformed dimensions mean the exact same thing with every possible fact table to which they are joined Ex:Date Dimensions is connected all facts like Sales fac...