SET BULKLOAD OPTIONS (POSTGRES ENGINE) TO SCD2 TRANSFORMATION IN DIS

[Egrodrigues2014]

Hi everyone,

When I set BULK LOAD option as active, SCD2 transformation create the following code (for ETLS_CLOSE as example):

      proc append base = EXT_VI."W6B3BTSM"n
         (
            BULKLOAD=YES
         )
         data = work."ETLS_CLOSE"n force; 
      run;

But this code doesn't work. I need to set "bl_psql_path='/PATH' " and "bl_delete_datafile=no" dataset option to BULKLOAD works properly.

I aware that I can change the automatic generated code to add these options.

Is there a way to configure these options at the transformation level? Or a way that I can add these options without change the code manually?

Thanks in advance.