-
Fact vs Dimension Table
Which table is large terms of size, fact table or dimension table? Explain
-
Data Extraction Tools
What are the different tools available for Data Extraction
-
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.
-
Dimension Modelling types along with their significance
Data Modelling is Broadly classified into 2 types. a) E-R Diagrams (Entity - Relatioships). b) Dimensional Modelling.