PROFDATREL

Profile Data Source

The Profile Data Sources (PROFDATAREL) file contains information about the data source that is used with the information transfer profile indicated.
UPDATED BY
IA10.1 IA10.2 IA11.1 IA16.1 IASV.1 IASV.2
IA120 IA150 IA13.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PFL-DATA-MART-NAME
Element: Data Mart Name
Alpha 20 (Lower Case)
This field contains the name of the data mart.
IA11.1 IA16.1
IASV.1
PFL-PROFILE-NAME
Element: Profile Name
Alpha 12 (Lower Case)
The Profile name field contains the 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.
IA11.1 IA16.1
IASV.1
PFL-DATA-LOAD-NAME
Element: Data Load Name
Alpha 12 (Lower Case)
The Data Source Name field contains the 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.
IA11.1 IA16.1
IASV.1


PROFDATREL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PFLSET1 DATA-MART-NAME
PROFILE-NAME
DATA-LOAD-NAME
KeyChange
IA10.1 IA10.2
IA11.1 IA120
IA150 IA16.1
IASV.2
PFLSET2 DATA-MART-NAME
DATA-LOAD-NAME
PROFILE-NAME
KeyChange
IA13.1


PROFDATREL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Olapprof OLAPPROF
PFL-DATA-MART-NAME->OLP-DATA-MART-NAME
  OLP-DATA-MART-GRP
  OLP-PROFILE-NAME


File created: Wed Jun 08 20:49:34 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.