KyaPoocha.com

Related Interview Questions

• What is Extension table?  26.09.08

  My understand is "base table has default colums. But Extension table is the table in which we can add additional columns other than its base tables columns I...

• What are non-additive facts ?  24.09.08

  fact table typically has two types of columns: those that contain numeric facts (often called measurements), and those that are foreign keys to dimension tabl...

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

• After a table is defined, can columns be removed ?  25.07.08

  The only way to remove columns from an existing table involves a migration program that extracts only the desired columns of data, redefining the table without...

• After a table is defined, can columns be removed ?  14.07.08

  The only way to remove columns from an existing table involves a migration program that extracts only the desired columns of data, redefining the table without...

• What are some characteristics of columns that benefit from indexes ?  01.04.08

  Primary key and foreign key columns;  columns that have unique values; columns that have aggregates computed frequently and columns used to test the existence...

• can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?  21.03.08

  yes possible. until the updation or selection is committed db2 table will not be restructured. new column definition will be there but it will not be included u...

• What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables?  17.03.06

  Snapshot facts are semi-additive, while we maintain aggregated facts we go for semi-additive. EX: Average daily balance A fact table without numeric fact colu...