ADD_LOADER_BD

Add new CFI-Loader(BD).

Table: CFIADM.CFI_LOADER_BD (BDomain specific CFI loader definitions)

Parameter Name	Properties	Default Value	Parameter Description
p_ldr_name	(PK)(NN)		Name of the loader process for a specific file as defined in CFI_LOADER.LDR_NAME (foreign key)
p_bdomain	(PK)(NN)		Name of the business domain as defined in CFI_BDOMAIN_SETTINGS.BDOMAIN (foreign key)
p_imp_type	(NN)		Data format of the file to be loaded. Possible values: CSC or FBV
p_file_name_pattern	(NN)		Regular expression that matches one or more file names to be loaded
p_bdate_pattern			If the file name contains the BDATE: regular expression that matches the BDATE-part of the file name.
p_bdate_fmt			If the file name contains the BDATE: format of the BDATE contained in the file name for conversion to timestamp.
p_tsa_schema	(NN)		Target schema name in the TSA layer.
p_tsa_table	(NN)		Target table name in the TSA layer.
p_active	(NN)		Turn loader on/off. Possible values: true or false.
p_bdate_epoch			BDATE for initial load in case of master data without date information
p_status_finished_offset	(NN)	0	Offset in minutes from the date, when the status of the TSA table will change to ‘FINISHED’. Default value: 0
p_file_encoding	(NN)	‘UTF-8’	Character encoding of the file. Default value: UTF-8.
p_file_row_separator	(NN)	‘LF’	New line separator. Values: LF, CR, CRLF, NONE. ‘NONE’ is only allowed for FBV files
p_file_csv_null			Text that should be interpreted as a NULL value. Example: ‘na’. Only used for CSV files. Only applies to fields without field delimiters. Empty strings are always interpreted as NULL values.
p_file_skip_rows	(NN)	0	Number of rows to be skipped at the beginning of the file (e.g. header rows). Default value: 0.
p_file_csv_trim			Optional command to trim leading and/or trailing spaces in CSV columns. Values: LTRIM,RTRIM,TRIM
p_file_csv_column_separator			Column separator for CSV files. Default value: ‘,’ .
p_file_csv_column_delimiter			Column delimiter for CSV files. Default value: ‘”’ .
p_file_fbv_row_size			Optional row size for FBV files. The row size is needed to recognize the end of a row if the last column is empty.
p_file_reject_limit	(NN)	0	Allowed number of rows with errors before the import is terminated. Default value: 0. For FBV files the reject limit is always 0.
p_part_number_pattern			Regular expression to identify a part number within the file name. Only useful if data is split into several files with sequential file names
p_bdate_ffdl_prev_day	(NN)	TRUE	In case of a first FULL daily load (i.e. the first one after midnight) use the previous day for BDATE. Possible values: true or false
p_numeric_characters			Custom decimal and thousand separators. Must contain only 2 characters - one for each separator.

Example

EXECUTE SCRIPT api_cfiadm.add_loader_bd
            ( 'XXX'             -- p_ldr_name
            , 'XXX'             -- p_bdomain
            , 'XXX'             -- p_imp_type
            , 'XXX'             -- p_file_name_pattern
            , 'XXX'             -- p_bdate_pattern
            , 'XXX'             -- p_bdate_fmt
            , 'XXX'             -- p_tsa_schema
            , 'XXX'             -- p_tsa_table
            , FALSE             -- p_active
            , '2025-03-10'      -- p_bdate_epoch
            , 0                 -- p_status_finished_offset
            , 'UTF-8'           -- p_file_encoding
            , 'LF'              -- p_file_row_separator
            , 'XXX'             -- p_file_csv_null
            , 0                 -- p_file_skip_rows
            , 'XXX'             -- p_file_csv_trim
            , 'XXX'             -- p_file_csv_column_separator
            , 'XXX'             -- p_file_csv_column_delimiter
            , 0                 -- p_file_fbv_row_size
            , 0                 -- p_file_reject_limit
            , 'XXX'             -- p_part_number_pattern
            , FALSE             -- p_bdate_ffdl_prev_day
            , 'XXX'             -- p_numeric_characters
            );