Wednesday, March 13, 2013

Dropping of Keys and Constraints in Informatica

When we load millions of records using informatica workflow with keys and constaraints on the Target table then it can cause slowdown of the job.In such cases we need to drop the constraints and keys and then load the data.Otherwise the worklfow will run slow.Once all the records are loaded you can rebuild it.

Also as a convinent solution its  better to create Informatica stored procedure for dropping aswell as rebuilding of the constraints.Before running the Informatica workflow the stored procedure can be run as Pre and Post of workflow job.

No comments:

Post a Comment