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.

[LinusH]

Unsure if you can do this using standard options in the transformation.

But I am wondering if you have a good use case here.

S in SCD stands for Slowly, so you shouldn't have millions of records that needs closing out.

If not done so already, you could try the SQL Pass through option, it might speed up the process depending on the performance of your RDBMS.