I have a pipeline with a jdbc execute with a select sql from source (postgres), Oracle Delete of target table, Oracle insert of target table. I turn auto commit off in the target oracle account. But for some reason after the Oracle Delete snap SnapLogic still does a commit and the target table has zero records when queried from an outside session? I want the target table to have old data and then within a millisecond or so have new data. There should be no intermittent period of time where the table has zero records visible from an outside session. How do I make it so the pipeline deletes and inserts records in its own session and then commits flipping the table data from old to new immediately? If I wrote this in pl/sql I could do: delete from target_table; insert … into target_table; commit;
