Explain why fact table is in normal form?
- 1 Answers
- 1054 Views
- I also Faced
- E-Mail Answers
Answer / Sandeep Chauhan
Fact tables are designed to be in third normal form (3NF) or higher, to ensure data integrity and reduce redundancy. In 3NF, each non-key attribute depends on the primary key only, eliminating transitive dependencies. This helps prevent update anomalies and allows for easier data manipulation.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is META DATA information in Data warehousing projects?
When should one use an MD-database (multi-dimensional database) and not a relational one?
What is operational data store (ods)?
What is a staging area? Do we need it? What is the purpose of a staging area?
Explain what is data validation strategies for data mart validation after loading process?
What is the difference between datawarehouse and bi?
What is hash partition?
What is surrogate key?
Explain what are components of reportnet?
Explain the data type of the surrogate key?
I have two universes created by two difference database can we join them in designer & report level? How
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
Teradata 
