post.txt (30.27 KB)We are currently loading data from Source to STAGE and then Stage to Target ( after joining of multiple tables). -- we have a procedure written in SQL SERVER. Now would like to avoid the staging part and load the data directly from SORUCE to TARGET. ( modify the above script relevant to Source to Target using Oracle stored Procedure).
So we would like to load the data from SOURCE to TARGET ( INSTEAD OF STAGE) using ORCLE STORED PROCEDURE(Oracle 12 c). Please find teh below and advise to write a PROCEDURE which will load the data at faster rate.
Please check and advise.
Thanks