I feel that Dirty Dimension is nothing but Junk Dimensions. Core Dimensions are dedicated for a fact table or Datamart. Conformed Dimensions are used across fact tables or Datamarts. Sorry i never heard of Balanced Dimensions.Could some one explain what is Balanced Dimension?Regards,Ravi Kumar Garre
Core Dimension is a Dimension table which is used dedicated for single fact table or Datamart. Conform Dimension is a Dimension table which is used across fact tables or Datamarts.
sar
Apr 21st, 2007
Universe does not hold any data. however practically the universe?is known to have?issues when the objects cross 6000.
In Business Objects unvierse creation we do have two types of Hierarchies Custom and Default Hierarchies. Default hierarchies are by default all objects in a given class. For example Time Dimension. By default you can define Time Dimension Year, Quarter, Month and Day.
The galaxy schema is also know as fact constellation scheme.it requires no of fact tables to share dimension tables.in dataware housing mainly the people are using theconceptual hierarchy
The datawarehousing where all the operations activities maintained,?so?that?you?can?access?the?anaysed?data?from?adifferent?place.For example, take bank operations ... if A deposit 10,000/...
Drill across corresponds to switching from 1 classification in 1 dimension to a different classification in different dimenstion.
jyothi
Feb 12th, 2007
Drilling across is a process of moving down in the Hierarchy........where one can see the more generalized way of viewing the information.........ex : The year represented in quarter could be drilled across by specifying each month......
Data profiling is a way to find out what is the profile of the information contained in the source. e.g. In a table a column may be defined as alphanumeric. However majority of the data may be numeric...
Because bitmapped indexes map values in the column to bits and store only the bit values, storage is reduced by several orders when bitmapped indexes are used.
Ans