-
Fact vs Dimension Table
Which table is large terms of size, fact table or dimension table? Explain
goeljessica
- Sep 7th, 2012
Fact tables: Have any measurable value in it and it contain foreign key of all the dimension table.
Dimension Tables: Do not have any numeric value, and it shows the characteristics that describe a transaction.santhosh
- May 28th, 2012
Dimension:It gives description about fact.
Fact:Is knows as Key Identifier(Measures)
EX:
Empno Empname Sal Deptno
1 A 20,000 201
2 B 15,000 203
All facts are numeric -
Data Extraction Tools
What are the different tools available for Data Extraction
cyberdiptikanta
- Jul 26th, 2010
1.Informatica2.Datastage3.Ab-intio4.Oracle Warehouse Builder5.Oracle Data Integrator6.SSIS
smsreddy
- May 20th, 2009
Instead of Extraction we can say Intigration tools ( ETLs) some of those areInformaticaDatastageSASMicrosoft SSISOracle Warehouse Builder
-
Dimensional modelling is again sub divided into 2 types.
a)Star Schema - Simple & Much Faster. Denormalized form. b)Snowflake Schema - Complex with more Granularity. More normalized form.
cyberdiptikanta
- Jun 26th, 2010
Star Schema is performance wise better than Snow Flake Schema. As Star schema uses denormalise tables, so there will be less no of join as compared to Snow flake Schema.RegardsDiptikanta
shady2pac
- Oct 19th, 2008
Is not star schema better performance wise (querying) as it has less no of join due to denormalized structure? Please clarify
-
Dimension Modelling types along with their significance
Data Modelling is Broadly classified into 2 types. a) E-R Diagrams (Entity - Relatioships). b) Dimensional Modelling.
BHANU
- Jul 9th, 2013
Dimensional modeling is a technique for conceptualizing and visualizing the data there are two types of dimensional modeling
1.Snowflake schema
2.Star schema
cyberdiptikanta
- Jun 26th, 2010
Dimensional Modelling:It is a designing methodlogy for designing datawarehouse with dimensions& facts.It is of three types 1) Conceptual Modelling 2) Logical Modelling 3) Physical Modelling1) Conc...
