What is degenerate dimension table?
Degenerate Dimensions : If a table contains the values, which r neither dimesion nor measures is called degenerate dimensions.Ex : invoice id,empno
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 Snow Flake Schema ? 25.09.08
Snowflake schemas normalize dimensions to eliminate redundancy. That is, the dimension data has been grouped into multiple tables instead of one large table. Fo...What is degenerate dimension table? 24.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 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...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 Dimensional Modelling ? 18.09.08
Dimensional Modelling is a design concept used by many data warehouse desginers to build thier datawarehouse. In this design model all the data is stored in two...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 Snow Flake Schema? 17.03.06
Snowflake Schema, each dimension has a primary dimension table, to which one or more additional dimensions can join. The primary dimension table is the only tab...