Does Ab Initio support Oracle Merge statement?

10 pts.
Tags:
Ab initio
Oracle
Oracle Statements
I'm attempting to design an Ab Initio load process without any Ab Initio training or documentation. Yeah I know. A design decision is: for the incoming data files there will be inserts and updates. Should I have the feed provider split them into to data files (1 - 10 GB in size nightly) and have Ab Initio do inserts and updates separately? A problem I see with that, is data isn't always what you expect it to be... And an Insert row may be already present (perhaps purge failed or feed provider made a mistake) Or Update row isn't present. So I'm wondering if I should just combine all inserts and updates... and use Oracle Merge statement (after parallel loading the data into a staging table with no index of course) But I don't know if AbInitio supports Merge or not. There is not much for ab initio tutorials or docs on web... can you direct me to anything good?

Software/Hardware used:
Software

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi

Get in touch with your A>I account manager, they will be only too happy to help or try support@abinitio.com.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: