KyaPoocha.com

Related Interview Questions

• How can I use tables to structure forms?  01.12.08

  Small forms are sometimes placed within a TD element within a table. This can be a useful for positioning a form relative to other content, but it doesn't help...

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

• What is Normalization, First Normal Form, Second Normal Form , Third Normal Form ?  24.09.08

  Normalization : The process of decomposing tables to eliminate data redundancy is called Normalization. 1N.F:- The table should caontain scalar or atomic v...

• Why fact table is in normal form?  23.09.08

  I somewhat disagree venkat. There can just be SKs within a Star schema, which itself is de-Normalized. Now, if there are then FKs on the dimensions as well, I...

• what is BUS Schema?  22.09.08

  Bus Schema : Let we consider/explain these in x,y axis Dimension Table : A,B,C,D,E,F Fact Table: R,S...

• Why fact table is in normal form?  22.09.08

  I somewhat disagree venkat. There can just be SKs within a Star schema, which itself is de-Normalized. Now, if there are then FKs on the dimensions as well, I...

• What is the difference between star schema and snow flake schema ?and when we use those schema’s?  20.09.08

  Star Schema : Star Schema is a relational database schema for representing multimensional data. It is the simplest form of data warehouse schema that contains...

• 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 does level of Granularity of a fact table signify?  17.03.06

  Granularity The first step in designing a fact table is to determine the granularity of the fact table. By granularity, we mean the lowest level of information...

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