A class table is a single physical table that can store
multiple logical entities that have similar business attributes. Various
logical dimensions are separated by a separator column, such as, type or
category. W_XACT_TYPE_D is an example of a dimension class table. Different
transaction types, such as, sales order types, sales invoice types, purchase
order types, and so on, can be housed in the same physical table.
You can add additional transaction types to an existing
physical table and so reduce the effort of designing and maintaining new
physical tables. However, while doing so, you should consider that attributes
specific to a particular logical dimension cannot be defined in this physical
table. Also, if a particular logical dimension has a large number of records,
it might be a good design practice to define a separate physical table for that
particular logical entity.
No comments:
Post a Comment