| Informatica and Merge Usage [message #597991] |
Wed, 09 October 2013 11:40  |
Wah_has
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
