Can any one give me an example when to use the pre sql and post sqls in informatica?
Pre sql and post sqls are used to do some cleanup operations, auditing, index drop and creations on the database side.
Example: When you want to load a huge amount of data in the target table and the target table has indexes defined on it. Then the loading will take a lot of time. To improve the performance of laoding, in the pre sql first drop the indexes on the table, then load the data into the table and in the post sql create the indexes on the table.