How to improve performance of our mapping in informatica? What is Bottleneck and how can we save ourself from these problem and increase performance?
Printable View
How to improve performance of our mapping in informatica? What is Bottleneck and how can we save ourself from these problem and increase performance?
[QUOTE=goodwillhunter;12075]How to improve performance of our mapping in informatica? What is Bottleneck and how can we save ourself from these problem and increase performance?[/QUOTE]
Before going for for bottlenecks,
In testing, you have to test the loading of data into database, in general you can call it as data loading test.
Before loading to the target table i.e., which is there in your database. Load the data into a flat file target, so that you can find the bottlenecks are there at database level or at Mapping level.
If the bottlenecks are not there at database level, then you have to go further with the Mapping bottlenecks.....
In Mapping bottlenecks you can find the bottlenecks are at three levels from your informatica log file..
[LIST=1][*]Source level bottlenecks[*]Traget level bottlenecks[*]Transformation level bottlenecks[/LIST]
[I]If you need in detail document on these bottlenecks, I can give it later.[/I]