Multiple choice technology

What are the default attributes created when a dimension is created using Surrogate key option?

  1. LONG_DESCRIPTION

  2. SHORT_DESCRIPTION

  3. PARENT_CD

  4. CHILD_CD

  5. CD
Reveal answer Fill a bubble to check yourself
A,B Correct answer
Explanation

When creating a dimension using the Surrogate key option, Oracle AWM automatically generates LONG_DESCRIPTION and SHORT_DESCRIPTION attributes to store dimension member names and descriptions. These serve as the primary display fields in reports and UIs. PARENT_CD and CHILD_CD are relationship attributes that must be explicitly defined through hierarchy creation, not auto-generated.

Keep practicing — related questions