This design approach is used when the entity is logically
the same but participates as different roles in the business process. As an
example, an employee could participate in a Human Resources business process as
an employee, in the sales process as a sales representative, in the receivables
process as a collector, and in the purchase process as a buyer. However, the
employee is still the same. For such logical entities, flags have been provided
in the corresponding physical table (for example, W_EMPLOYEE_D) to describe the
record's participation in business as different roles.
While configuring the presentation layer, the same physical
table can be used as a specific logical entity by flag-based filters. For
example, if a particular star schema requires Buyer as a dimension, the
Employee table can be used with a filter where the Buyer flag is set to Y.
No comments:
Post a Comment