-
-
opposite is true?
">Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?
justins707
- Jan 11th, 2010
When we refer to Star and Snowflake Schemas, we are talking about a dimensional model for a Data Warehouse or a Datamart. The Star schema model gets it name from the design appearance because th...
Chris
- Mar 29th, 2007
Star Schemas generally contain fact tables with fully denormalised dimension tables connecting directly to the fact table. A snowflake schema is a modification of this approach whereby the dimension t...
-
What is Designer?
Designer is a BusinessObjects IS module used by universe designers to create and maintain universes. Universes are the semantic layer that isolates end users from the technical issues of the database structure. Universe designers can distribute universes to end users by moving them as files through the file system, or by exporting them to the repository.
sithusithu
- Jan 4th, 2006
DesignerIt is one of the business object?s componentsIt is used to create universesIt is used to define measures/metricsIt is used to do the calculationsSithu
senkumar79
- Oct 5th, 2005
Its a mapping of business requirements with the database structures in the database.
-
-
What are non-additive facts
sharuvijay
- Jan 28th, 2009
Non Additive facts cannot be aggregrated along with dimenstion in the fact table. For eg. Age, weather
vineela
- Jul 18th, 2007
Non additive facts are the facts that do not participate in arithmetic caliculations. for example in stock fact table there will be opening and closing balances along with qty sold and amt etc. but opening and closing balances were never used in arithmetic calculations.
-
What are slowly changing dimensions
swathirao_829
- Dec 6th, 2008
A Slowly Chaging dimension explains changed data captures over the period of time. There r three types of slowly changing dimensions(SCD).1)Type 1 SCD: It keeps most recent updated values in the targe...
1292033
- Aug 2nd, 2007
The definition of slowly changing dimension is in its name only. The dimension which changes slowly with time. A customer dimension table represents customer. When creating a customer, normal assum...
-
What does level of Granularity of a fact table signify
ibrarx
- Mar 7th, 2009
The level of granularity of a fact table signifies the smallest unit of analysis.
ravi kumar guturi
- Mar 9th, 2006
Granularity means nothing but it is a level of representation of measures and metrics.The lowest level is called detailed dataand highest level is called summary dataIt depends of project we extract fact table significanceBye
-
What is data mining
Answered by Puneet on 2005-05-07 04:24:28: Data mining is a process of extracting hidden trends within a datawarehouse. For example an insurance dataware house can be used to mine data for the most high risk people to insure in a certain geographial area.
kumarram
- Jun 11th, 2010
Data mining is the concept of extracting information from large data bases likes data wharehouse.
raj.rajeev15
- Sep 13th, 2009
Datamining is nothing but a science of finding information from databases or datasets.
-
-
What is a dimension table
Answer posted by Riaz Ahmad on 2005-06-09 14:45:26: A dimensional table is a collection of hierarchies and categories along which the user can drill down and drill up. it contains only the textual attributes.
Read Best Answer
Editorial / Best Answer
Answered by: Edmond
- Apr 13th, 2007
Let's be very clear. this is a very simple, and becomes a very confusing subject.
A fact table is an entity representing the numerical measurements of the business. A dimension table is the entity describing the textual representation of the business.
In a banking model, the account and balances are the measurements within the fact table, where customer name, social security, address, time period of the account, are the dimensions (customer/time).
Hope this answers the clarification.Anindya1281
- Jun 5th, 2011
In very simple termsFact : this contains all numeric attributesDimesion : this contains all non numeric , textual attributesIn order to rememberFact : Any answer to What user want to see is factfor ex...
mickey_gupta
- Mar 4th, 2009
Dimension table contains reference data which gives meaning to fact data. You can also view them as parameters across which you want to analyze the fact data.
-
What is Fact table
Answer posted by Chintan on 2005-05-22 18:46:03: A table in a data warehouse whose entries describe data in a fact table. Dimension tables contain the data from which dimensions are created.
munavar.shaik
- Jan 20th, 2011
A fact table is an entity representing the numerical measurements or metrics or facts of the business Eg: Billings table,Bookings table,Accounts tableA dimension table is the entity describing th...
ashwinijawalgekar
- Jun 9th, 2010
Fact table is a normalized table divided in to 2 parts Link to all dimension tables -> First part of fact table contains set of foreign keys which links to the respective dimension t...
-
What is the Difference between OLTP and OLAP
Answered by swetha on 2005-03-30 12:00:33: OLTP Current data Short database transactions Online update/insert/delete Normalization is promoted High volume transactions Transaction recovery is necessary OLAP Current and historical data Long database transactions Batch update/insert/delete Denormalization is promoted Low...
-
What are Aggregate tables
kevin0209
- Aug 30th, 2010
Aggregate table contains summarised data. The materialized view are aggregated tables.
sixto.dsilva
- Oct 1st, 2008
Aggregate table contains the summary of existing warhouse data , it contains data which is group accordingly (month , quartely etc) depending upon the business needs.For example you may contain transa...
-
What Snow Flake Schema
Answered by Girinath.S.V.S on 2005-03-17 06:40:48: Snowflake schemas normalize dimensions to eliminate redundancy. That is, the dimension data has been grouped into multiple tables instead of one large table. For example, a product dimension table in a star schema might be normalized into a products table, a product_category table, and a product_manufacturer table in a snowflake schema. While this...
prodyot.sarkar
- May 13th, 2010
Snow-flake schema is a logical arrangement of tables in dimensional modeling where a centralized fact table references number of other dimension tables; however, those dimension tables are further nor...
harshadapj
- Jul 22nd, 2008
Closely related to the star schema, the snowflake schema is represented by centralized fact tables which are connected to multiple dimensionsIn the snowflake schema, however, dimensions are normalized...
-
What is a Star Schema
Answer posted by Chintan on 2005-05-22 18:34:55: A relational database schema organized around a central table (fact table) joined to a few smaller tables (dimension tables) using foreign key references. The fact table contains raw numeric items that represent relevant business facts (price, discount values, number of units sold, dollar value, etc.)
