ADD_LOADER_BD

Add BDomain specific metadata to a DBI loader.

Parameter Name	Required	DefaultValue	Description
p_ldr_name	yes		loader name
p_bdomain	yes		bdomain
p_src_db_name	yes		source database name
p_src_connection	yes		source connection - check if not exasol db
p_tsa_schema	yes		target schema
p_tsa_table	yes		target table
p_active	yes	true	active
p_bdate_epoch	yes		bdate epoch
p_status_finished_offset	yes		status finished offset
p_ext_bdate_sql_expr	yes		external bdate SQL expression
p_bdate_ffdl_prev_day	yes	true	bdate ffdl previous day
p_src_view_gen	yes		source view generation
p_src_where_clause	yes		source where clause
p_ct_enabled	yes	false	ct enabled
p_ct_group	yes		ct group - empty if p_ct_enabled = false
p_split_max_degree	yes		max. parallel degree for import
p_split_on_load_abort	yes		split import if it results in an error due to connection abort
p_priority	yes		priority of loader, lower value means higher priority

Example

EXECUTE SCRIPT api_dbiadm.add_loader_bd
            ( 'Loader1'          -- p_ldr_name
            , 'R32'              -- p_bdomain
            , 'SourceDB1'        -- p_src_db_name
            , 'ZDW_R32_A'        -- p_src_connection
            , 'TSA_Schema1'      -- p_tsa_schema
            , 'TSA_Table1'       -- p_tsa_table
            , true               -- p_active
            , '2022-01-01'       -- p_bdate_epoch
            , 5                  -- p_status_finished_offset
            , ''                 -- p_ext_bdate_sql_expr
            , null               -- p_bdate_ffdl_prev_day
            , ''                 -- p_src_view_gen
            , ''                 -- p_src_where_clause
            , false              -- p_ct_enabled
            , 'CT_Group1'        -- p_ct_group
            , null               -- p_split_max_degree
            , null               -- p_split_on_load_abort
            , null               -- p_priority
            );