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
B) transactional source normally conform 3 NF (1) single value (2) no partial dependency (3) no dependency between non-primary column
B