Hi @LinusH , We need to load the historical records and this data volume will be only in the first iteration. As you can see, we change the option "Upload library before targe table update" to EXT_VI library. But the "etls" tables still in work library. /* Delete the work tables */
proc datasets lib=EXT_VI nolist nowarn memtype = (data view);
delete "W6B3TJ5F"n;
delete "W6B3TIUB"n;
delete "W6B3TIOR"n;
quit;
proc datasets lib=work nolist nowarn memtype = (data view);
delete etls_newrcds;
delete etls_match;
delete etls_close;
quit; To load data from work to postgres tables, we need to set bulkload. Is there a way so that these tables are also generated in the "EXT_VI" (postgres) library ? Thus, passthrough can be performed without the need for BULKLOAD. We set "Libref to copy temporary work tables to" SCD option to EXT_VI, but it does not work. Thanks in advance.
... View more