The database view which SCD uses as the source.
Example:
DIM_BANDS_V
These views come as part of install for the dimensions seeded with the application.
|
NOTE |
For any new dimension added, a view will have to be created similar to DIM_BANDS_V. |
DIM_<dimensionname>: Output table to which SCD writes the dimension data. A sequence must be added for every user-defined dimension.
Example:
create sequence SEQ_DIM_<DIM> minvalue 1
maxvalue 999999999999999999999999999
increment by 1