If a Mapping is running slow, What steps you will take, to correct it?

Questions by boisee

Showing Answers 1 - 3 of 3 Answers

vinodh259

  • May 11th, 2007
 

provide optimizer hints to the informatica. such as force informatica to use indexes, synonyms, etc ..
best technique is find ehich trnsformation is makin the mapping slow and  with that logic build a query in the databse and see how the database executing plan. to see the plan how database executing plan for example EXPLAIN PLAN command in oracle helps u . for more information try help topics in power designer. in help lookfor optimizing hints

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions