DATASOURCE FILE
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
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 Alpha 20 (Lower Case) IA10.1 IA13.1
Data Mart Name IASV.1
DAT-DATA-LOAD-NAME Alpha 12 (Lower Case) IA10.1 IA13.1
Data Source Name The Data Source Name field contains the IASV.1
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.
DAT-DATA-PROGRAM Alpha 6 IA10.1 IA13.1
Data Load Program The Data Values Load program is the IASV.1
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.
DAT-DATA-FORMAT Alpha 1 IA10.1 IA13.1
Data Load Format The Data Load Format field contains the IASV.1
format of the data source.
Valid values are:
1 = Program load; Default value.
2 = Rules File load
DAT-DATA-PATH-NAME Alpha 100 (Lower Case) IA10.1 IA13.1
Data Source File The Data Source File field contains the IASV.1
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).
DAT-RULES-FILE Alpha 100 (Lower Case) IA13.1
Rules File 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).
DAT-FILE-FORMAT Alpha 1
Text File Format 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 Numeric 8 (yyyymmdd) IA10.2 IA120
Data Load Date The Data Load Date field contains the IA150 IASV.2
most recent date that the OLAP data mart
was populated with data values. The date
format used is YYYYMMDD.
DAT-DATA-BUILD-TME Numeric 6 (hhmmss) IA10.2 IA120
Data Load Time The Data Load Time field contains the IA150 IASV.2
most recent time that the OLAP data mart
was populated with data values. The time
format used is HHMMSS.
DATASOURCE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DATSET1 DATA-MART-NAMEKeyChange IA10.1 IA10.2
DATA-LOAD-NAME IA120 IA13.1
IA14.1 IA150
IA16.1 IA200
IASV.2
DATSET2 DATA-LOAD-NAMEKeyChange
DATA-MART-NAME
DATASOURCE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|
