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