Discussion
Every key used to join the fact table with a dimensional table should be a surrogate key.
Answer: A
Correct answer: True
A surrogate key is a meaningless integer generated for the warehouse, and using one insulates the schema from the operational keys, which may be reused, may change format, or may collide between source systems. It also makes possible the slowly changing dimension, where several rows describe the same real entity at different times.
No comment is present. Be the first to comment.
Loading…
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development