KyaPoocha.com

Related Interview Questions

• 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 Dimensional Modelling?  23.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...

• What is BUS Schema?  20.09.08

  BUS Schema is composed of a master suite of confirmed dimension and standardized definition if facts. In a BUS schema we would eventually have conformed dimens...

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

• What are the fundamental differences between value types and reference types?  24.08.06

  C# divides types into two categories - value types and reference types. Most of the intrinsic types (e.g. int, char) are value types. Structs are also value typ...

• What are non-additive facts in detail?  04.08.06

  A fact may be measure, metric or a dollar value. Measure and metric are non additive facts. Dollar value is additive fact. If we want to find out the amount...

• 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 non-additive facts?  17.03.06

  Non-Additive: Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table....

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

• What is Reference type and value type ?  14.03.06

  Reference Type: Reference types are allocated on the managed CLR heap, just like object types. A data type that is stored as a reference to the value's location...