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

Dimensions that change over time are called Slowly Changing Dimensions. For instance, a product price changes over time; People change their names for some reason; Country and State names may change over time. These are a few examples of Slowly Changing Dimensions since some changes are happening to them over a period of time

Post Your Answer!
Send This to a Friend

← What are modeling tools available in the Market ?
What are Data Marts ? →

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 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...

  • What are slowly changing dimensions?  17.03.06

    SCD stands for Slowly changing dimensions. Slowly changing dimensions are of three types SCD1: only maintained updated values. Ex: a customer address modified...