DATASOURCE – Data Source

System: Analytic Architect (IA)
Prefix: DAT
Primary key: DATA-MART-NAME, DATA-LOAD-NAME
Fields: 9
Updated by: 7 programs
Referenced by: 4 programs

DATASOURCE is the Data Source table in Lawson Analytic Architect (prefix DAT). It is indexed by DATA-MART-NAME, DATA-LOAD-NAME (DATSET1); alternate indexes: DATSET2. It is related 1:1 to OLAPDBM and 1:M to DIMDATAREL. It is updated by IA10.1, IA10.2, IA120, IA13.1, IA150, IASV.1 and IASV.2 and referenced by IA11.1, IA14.1, IA16.1 and IA200. The table has 9 fields, 2 indexes and 2 documented relations.

About DATASOURCE

The Data Source (DATASOURCE) file contains information about the data source used for loading the data mart. The information in this file comes from IA13.1 (Data Load Sources).

Fields (9)

Column = COBOL field name without the DAT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`DAT-DATA-MART-NAME` PK DATA_MART_NAME	Alpha 20 (Lower Case)	This field contains the name of the data mart.	IA10.1, IA13.1, IASV.1
`DAT-DATA-LOAD-NAME` PK 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.	IA10.1, IA13.1, IASV.1
`DAT-DATA-PROGRAM` DATA_PROGRAM	Alpha 6	The Data Values Load program is the program that the Analytic Architect system calls to supply the data values to the data mart. This may be the same program as the Outline Build program.	IA10.1, IA13.1, IASV.1
`DAT-DATA-FORMAT` DATA_FORMAT	Alpha 1	The Data Load Format field contains the format of the data source. Valid values are: `1` Program load; Default value. `2` Rules File load	IA10.1, IA13.1, IASV.1
`DAT-DATA-PATH-NAME` DATA_PATH_NAME	Alpha 100 (Lower Case)	The Data Source File field contains the name of the data source file. If a data load program has been specified in the Data Load Program field, the output of the data load program is placed in the data source file using the path specified in the CSV Output Path field in IA100 (Data Mart Type Load). If a rules file is used, the source of the data being loaded into the data mart is the data source file. Both the rules file and the data source file must be placed in the $ARBORPATH/app/application name/database path before using IA120 (Data Mart Load).	IA10.1, IA13.1, IASV.1
`DAT-RULES-FILE` RULES_FILE	Alpha 100 (Lower Case)	The Rules File field contains file name of the rules file to be used by the data mart. If a rules file is used, the data source is the file specified in the Data Source File field. The rules file is responsible for loading the data source file into the data mart. Both the rules file and the data source file must be placed in the $ARBORPATH/app/application name/database path before using IA120 (Data Mart Load).	IA13.1
`DAT-FILE-FORMAT` FILE_FORMAT	Alpha 1	The File Format field contains the value that indicates the layout of the text file when a data load program is used to create a text file. Valid values are: Blank or spaces = Unused. The target destination of the data load program is the data mart. value defined in a row. headers generated by the data load program; Default value. " " = Unused `R` CSV file contains Members of a data `P` CSV file contains page and column	—
`DAT-DATA-BUILD-DTE` DATA_BUILD_DTE	Numeric 8 (yyyymmdd)	The Data Load Date field contains the most recent date that the OLAP data mart was populated with data values. The date format used is YYYYMMDD.	IA10.2, IA120, IA150, IASV.2
`DAT-DATA-BUILD-TME` DATA_BUILD_TME	Numeric 6 (hhmmss)	The Data Load Time field contains the most recent time that the OLAP data mart was populated with data values. The time format used is HHMMSS.	IA10.2, IA120, IA150, IASV.2

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
`DATSET1`	`DATA-MART-NAME`, `DATA-LOAD-NAME`	Primary, KeyChange		IA10.1, IA10.2, IA11.1, IA120, IA13.1, IA14.1, IA150, IA16.1 +2 more
`DATSET2`	`DATA-LOAD-NAME`, `DATA-MART-NAME`	KeyChange		—

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Olapdbm	OLAPDBM	Required		`DAT-DATA-MART-NAME` → `ODB-DATA-MART-NAME (ODBSET1)`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Dimdatarel	DIMDATAREL			`DAT-DATA-MART-NAME` → `DDR-DATA-MART-NAME`, `DAT-DATA-LOAD-NAME` → `DDR-DATA-LOAD-NAME`, → `DDR-USER-DIM-NAME`

Programs

Updated by (7)

IA10.1 Data Mart Manager
IA10.2 Data Mart Delete
IA120 Data Mart Load
IA13.1 Data Load Sources
IA150 XML Data Mart Interface
IASV.1 Service Bureau Data Marts
IASV.2 Olap Database Delete

Referenced by (4)

IA11.1 Information Transfer Profiles
IA14.1 Dimension Member Override
IA16.1 Profile Data Sources
IA200 Unix ESSCMD Interface