Why is it necessary to join multiple source tables to a single dimension?

The correct answer is B. Because transactional source systems are often normalized. Denormalized data in the transactional system could be divided into different tables to increase

Adding Multiple Logical Table Sources to a Logical Table

Question

Options

ABecause transactional source systems are often denormalized
BBecause transactional source systems are often normalized
CBecause a single source table often contains all the dimensions needed
DBecause the dimensions tables are built in the transactional systems

How the community answered

(40 responses)

A
15% (6)
B
75% (30)
C
5% (2)
D
5% (2)

Explanation

Denormalized data in the transactional system could be divided into different tables to increase

Topics

#normalized source systems#dimensional modeling#logical table sources#physical joins

Community Discussion

No community discussion yet for this question.

Full 1Z0-591 Practice