The Oracle Business Analytics
Warehouse uses suffixes to indicate fields that must contain specific values,
as shown .
|
Suffix
|
Description
|
In Table Types
|
|
_CODE
|
Code field.
|
_D, _DS, _FS, _G, _GS
|
|
_DT
|
Date field.
|
_D, _DS, _FS, _G, _DHL, _DHLS
|
|
_ID
|
Correspond to the _WID columns of
the corresponding _F table.
|
_FS, _DS
|
|
_FLG
|
Indicator or Flag.
|
_D, _DHL, _DS, _FS, _F, _G, _DHLS
|
|
_WID
|
Identifier generated by Oracle
Business Intelligence linking dimension and fact tables, except for ROW_WID.
|
_F, _A, _DHL
|
|
_NAME
|
A multi-language support column
that holds the name associated with an attribute in all languages supported
by the data warehouse.
|
_TL
|
|
_DESCR
|
A multi-language support column
that holds the description associated with an attribute in all languages
supported by the data warehouse
|
_TL
|
No comments:
Post a Comment