Why is it necessary to join multiple source tables to a single dimension?
A.
Because transactional source systems are often denormalized
B.
Because transactional source systems are often normalized
C.
Because a single source table often contains all the dimensions needed
D.
Because the dimensions tables are built in the transactional systems
Explanation:
Denormalized data in the transactional system could be divided into different tables
to increase performance.
Wrong answer, it should be A because transactional systems are always denormalized.
sorry for the mess, the answer is correct
the silly question the silly answer
B
Joining multiple tables means denormalization.
So the correct answer is the opposite: B – Because transactional source systems are often normalized
B) is not always correct: what if the OBIIE connects to one OLAP like oracle data ware house which is not transactional database?