- Home
- Interview Questions
- Data Warehousing
Repeating groups must beeliminated, Dependencies can be identified, All key attributesdefined,No repeating groups in table
The Table is already in1NF,Includes no partial dependencies–No attribute dependent on a portionof primary key, Still possible to exhibit transitivedependency,Attributes may be functionally dependent on non-keyattributes .
The Table is already in 2NF, Contains no transitive dependencies .
Fact Table contains the measurements or metrics or facts of business process. If your business process is "Sales" , then a measurement of this business process such as "monthly sales number" is captured in the Fact table. Fact table also contains the foriegn keys for the dimension tables
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 facts,Inventory facts..etc
|
|
||||||||||||||||||||||||||||
