Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Informatica Target Update Performance Improvement
This is a discussion on Informatica Target Update Performance Improvement within the Data Warehousing forums, part of the Databases category; Hi all, I am writing a mapping which will pull out data from database, do modification (simple modification using expression) and update the same table. Expected number of records to ...
|
|||||||
09-28-2009
|
|||
|
|||
|
Informatica Target Update Performance Improvement
Hi all,
I am writing a mapping which will pull out data from database, do modification (simple modification using expression) and update the same table. Expected number of records to be updated is 2 millions. The source table doesn't have primary key, but it has an id column which was indexed. I used target session parameter of update as update. I found the throughput of the process is way too low, it starts with 1000 records/second but keep decreasing until less than 10 records/seconds. I wonder how to improve this throughput considering the amount of data to be processed. Regards, st_laurent 
|
| Sponsored Links |
|
09-30-2009
|
|||
|
|||
|
Re: Informatica Target Update Performance Improvement
Disable the index while updating and rebuild the same after the update process is over.
|
|
10-11-2009
|
|||
|
|||
|
Re: Informatica Target Update Performance Improvement
Remove all target tables index's and load the data after rebuild the same index.
Hope this helps.
|
 |
|
| Tags |
| informatica |
«
Difference between Query calculation and Layout calculation
|
Informatica Performance Issue Identification
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Informatica Performance Issue Identification | ash22 | Data Warehousing | 2 | 10-11-2009 01:00 AM |
| Target Table Update | Sant_parkash | Data Warehousing | 2 | 05-12-2009 06:14 AM |
| How can we insert or update the records in target | rasmi | Data Warehousing | 2 | 09-03-2007 09:49 AM |
| Answer for Improvement | janelyn | Interviews | 1 | 08-29-2006 05:03 AM |
| Points for Performance Improvement | Robert | Web Design | 0 | 08-11-2006 02:54 PM |
All times are GMT -4. The time now is 03:19 PM.
