DATASOURCE

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
IA11.1 IA14.1 IA16.1 IA200


UPDATED BY
IA10.1 IA10.2 IA120 IA13.1 IA150 IASV.1
IASV.2

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DATSET1 DATA-MART-NAME
DATA-LOAD-NAME
KeyChange
IA10.1 IA10.2
IA11.1 IA120
IA13.1 IA14.1
IA150 IA16.1
IA200 IASV.2
DATSET2 DATA-LOAD-NAME
DATA-MART-NAME
KeyChange


DATASOURCE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Olapdbm OLAPDBM Required
DAT-DATA-MART-NAME->ODB-DATA-MART-NAME (ODBSET1)


DATASOURCE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Dimdatarel DIMDATAREL
DAT-DATA-MART-NAME->DDR-DATA-MART-NAME
DAT-DATA-LOAD-NAME->DDR-DATA-LOAD-NAME
  DDR-USER-DIM-NAME


File created: Thu Jun 09 02:18:00 2016

Home
Contact Us



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