KyaPoocha.com

Related Interview Questions

• What is junk dimension? What is the difference between junk dimension and degenerated dimension?  23.09.08

  A junk dimension is a collection of random transcational codes, flags and text attributes that are unrelated to any particular dimension.The junk dimension is s...

• Give examples of degenerated dimensions ?  22.09.08

  Degenerated Dimension is a dimension key without corresponding dimension. Example: In the PointOfSale Transaction Fact table, we have: Date...

• 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 the need of surrogate key;why primary key not used as surrogate key Surrogate key is system generated unique number ?  22.09.08

  Identity in SQL, Sequence in Oracle, Sequence Generator in Informatica. For Example : You are extracting Customer Information from OLTP Source and after ETL...

• what is junk dimension? what is the difference between junk dimension and degenerated dimension?  20.09.08

  Junk dimension: Grouping of Random flags and text Attributes in a dimension and moving them to a separate sub dimension. Degenerate Dimension: Keeping the co...

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

• Differences between star and snowflake schemas ?  18.09.08

  Star schema A single fact table with N number of Dimension Snowflake schema Any dimensions with extended dimensions are know as snowflake schema star schema...

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

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