Home » Fusion Middleware & Colab Suite » Business Intelligence » Informatica and Merge Usage (Oracle 10G)
Informatica and Merge Usage [message #597991] Wed, 09 October 2013 11:40 Go to next message
Messages: 7
Registered: July 2006
Location: Lahore
Junior Member
I have a question, suppose we have to move data from a DB like SQL Serve/DB2 to Oracle, The Source table size is 200GB. This is done through Informatica Designer

We simply picked records and Then insert them in a Temp Table, After that we use MERGE Statement in oracle Store procedure to populate the records in Target Table.

• At first, we pick 200GB Data and put it in temp Table, after that SP Called in which we use MERGE Statement, which populate records in Target Table from Temp Table.
• Second time, suppose, 100MB Data is inserted and 200MB data is Updated (or vise versa) in Source Table, we pick those 300MB data in temp Table now Did Merge Statement perform Fast or we should use some other logic to populate the result.

Also let us know the Drawback of Merge statement.
Re: Informatica and Merge Usage [message #598011 is a reply to message #597991] Wed, 09 October 2013 13:43 Go to previous message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Wah_has wrote on Wed, 09 October 2013 22:10

At first, we pick 200GB Data and put it in temp Table

200 GB data at once? How? using Informatica?

[Updated on: Wed, 09 October 2013 13:44]

Report message to a moderator

Previous Topic: dynamic position column in BI publisher
Next Topic: BI publisher Browser window
Goto Forum:

Current Time: Tue Jun 22 12:36:25 CDT 2021