|
|
PROFDATREL FILE
Profile Data Source
The Profile Data Sources (PROFDATAREL) file contains information about the
data source that is used with the information transfer profile indicated.
REFERENCED BY
IA120 IA150 IA13.1
UPDATED BY
IA10.1 IA10.2 IA11.1 IA16.1 IASV.1 IASV.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PFL-DATA-MART-NAME Alpha 20 (Lower Case) IA11.1 IA16.1
Element: Data Mart NameThis field contains the name of the data IASV.1
mart.
PFL-PROFILE-NAME Alpha 12 (Lower Case) IA11.1 IA16.1
Element: Profile Name The Profile name field contains the IASV.1
name of the profile that is defined in
the IA11.1 (Information Transfer
Profiles) form. Each profile name
represents a run option that is used
when the data mart is updated. Run
options include the name of the calc
script, the outline load and data values
load options no load, incremental or
complete), and the names of the outline
dimensions to include in the build. This
user-defined field can contain up to 12
characters.
PFL-DATA-LOAD-NAME Alpha 12 (Lower Case) IA11.1 IA16.1
Element: Data Load NameThe Data Source Name field contains the IASV.1
unique name for the source containing
the data values you are loading. You can
define multiple data sources for a
single data mart. Examples of data
sources are programs or rules files.
This user-defined name can contain up to
12 characters of any kind.
PROFDATREL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PFLSET1 DATA-MART-NAMEKeyChange IA10.1 IA10.2
PROFILE-NAME IA11.1 IA120
DATA-LOAD-NAME IA150 IA16.1
IASV.2
PFLSET2 DATA-MART-NAMEKeyChange IA13.1
DATA-LOAD-NAME
PROFILE-NAME
PROFDATREL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Datasource DATASOURCE Required
PFL-DATA-MART-NAME -> DAT-DATA-MART-NAME
PFL-DATA-LOAD-NAME -> DAT-DATA-LOAD-NAME
Olapdbm OLAPDBM Required
PFL-DATA-MART-NAME -> ODB-DATA-MART-NAME
PROFDATREL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Olapprof OLAPPROF
PFL-DATA-MART-NAME -> OLP-DATA-MART-NAME
OLP-DATA-MART-GRP
OLP-PROFILE-NAME
|
