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 |
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. |
|
||||
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. |
|
||||
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. |
|
||||
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 |
|
||||
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). |
|
||||
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). |
|
||||
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. |
|
||||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DATSET1 |
DATA-MART-NAME DATA-LOAD-NAME |
|
| ||||||||||||||||
DATSET2 |
DATA-LOAD-NAME DATA-MART-NAME |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
---|---|---|---|---|---|
Olapdbm | OLAPDBM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Dimdatarel | DIMDATAREL |
|
All trademarks and registered trademarks are the property of their
respective owners.