Data Source

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).

REFERENCED BY

IA200

UPDATED BY

IA10.1	IA10.2	IA120	IA13.1	IA150	IASV.1
IASV.2	IA11.1	IA14.1	IA16.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
DAT-DATA-MART-NAME Element: 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 Element: Data Source 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 Element: Data Load 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 Element: Data Load 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 Element: Data Source File	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 Element: 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 Element: Text 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. R = CSV file contains Members of a data value defined in a row. P = CSV file contains page and column headers generated by the data load program; Default value. " " = Unused
DAT-DATA-BUILD-DTE Element: Data Load Date	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 Element: Data Load Time	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

DATASOURCE FILE INDEX

DATASOURCE FILE RELATIONS

ONE TO ONE RELATIONS

DATASOURCE FILE RELATIONS

ONE TO MANY RELATIONS

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