Learning Informatica PowerCenter 10.x - Second Edition

Dropping indexes and constraints

Loading data in the table takes more time because there are multiple indexes and constraints created on the table. Each time a new record is loaded in the table, it is first checked for indexes and constraints. This hampers the performance. To avoid this, you can use pre-SQL and post-SQL commands in the Session task. Using pre-SQL commands, you can remove the indexes, and using post-SQL, you can apply the indexes. When you define pre-SQL and post-SQL, Informatica applies those commands before and after the data is loaded in the table.

Removing the indexes and constraints is not always recommended, but it definitely improves the performance. You can opt for this option if the data that you are loading is not ...