PROFDATREL – Profile Data Source
- System
- Analytic Architect (IA)
- Prefix
PFL- Primary key
DATA-MART-NAME,PROFILE-NAME,DATA-LOAD-NAME- Fields
- 3
- Updated by
- 6 programs
- Referenced by
- 3 programs
PROFDATREL is the Profile Data Source table in Lawson Analytic Architect (prefix PFL). It is indexed by DATA-MART-NAME, PROFILE-NAME, DATA-LOAD-NAME (PFLSET1); alternate indexes: PFLSET2. It is related 1:1 to DATASOURCE and OLAPDBM and 1:M to OLAPPROF. It is updated by IA10.1, IA10.2, IA11.1, IA16.1, IASV.1 and IASV.2 and referenced by IA120, IA13.1 and IA150. The table has 3 fields, 2 indexes and 3 documented relations.
About PROFDATREL
The Profile Data Sources (PROFDATAREL) file contains information about the data source that is used with the information transfer profile indicated.
Fields (3)
Column = COBOL field name without the PFL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PFL-DATA-MART-NAME PKDATA_MART_NAME | Alpha 20 (Lower Case) | This field contains the name of the data mart. | IA11.1, IA16.1, IASV.1 |
PFL-PROFILE-NAME PKPROFILE_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 PKDATA_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 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PFLSET1 | DATA-MART-NAME, PROFILE-NAME, DATA-LOAD-NAME | Primary, 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 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Olapprof | OLAPPROF | PFL-DATA-MART-NAME → OLP-DATA-MART-NAME, OLP-DATA-MART-GRP, OLP-PROFILE-NAME |
Programs
Updated by (6)
- IA10.1 Data Mart Manager
- IA10.2 Data Mart Delete
- IA11.1 Information Transfer Profiles
- IA16.1 Profile Data Sources
- IASV.1 Service Bureau Data Marts
- IASV.2 Olap Database Delete