Which of the following BEST describes transformation rules used in data warehousing? Transformation rules are:

Question

Options

• AComplex for the staging layer but minimal for the presentation layer.
• BMinimal for the staging layer but more complex for the presentation layer.
• CMinimal for both the staging layer and presentation layer.
• DComplex for both the staging layer and presentation layer.

• A
  7% (2)
• B
  71% (20)
• C
  4% (1)
• D
  18% (5)

Explanation

Option B is correct because the staging layer functions primarily as a landing zone for raw source data - transformations there are kept minimal (light cleansing, deduplication, basic type casting) to preserve fidelity and load speed. The presentation layer is where business logic kicks in: dimensional modeling, aggregations, surrogate keys, slowly changing dimension handling, and derived metrics all make transformations significantly more complex.

Why the distractors are wrong:

• A reverses the reality - heavy transformation in staging would defeat its purpose as a raw-data buffer and create performance bottlenecks early in the pipeline.
• C understates the presentation layer's role; producing analyst-ready, business-aligned data requires substantial transformation logic, not minimal effort.
• D overstates the staging layer's complexity - keeping staging lean is a deliberate architectural choice that improves auditability and re-processability.

Memory tip: Think of staging as a "storage locker" (dump it in, don't overthink it) and the presentation layer as the "showroom" (everything must be polished, structured, and meaningful for business users). Complexity lives where the audience lives.

No community discussion yet for this question.