Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

0 Answers  


what is the difference between onsite & client site?

1 Answers  


what is parameter file?

1 Answers   Cap Gemini,


What are partitions in informatica and which one is used for better performance?

2 Answers  


r u done any partitions in ur project?

0 Answers   TCS,






What is workflow? What are the components of workflow manager?

0 Answers  


What is target update override

2 Answers   CTS,


What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,


Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  


can we override a native sql query within informatica? Where do we do it?

0 Answers  


What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,


What is the difference between a shortcut of an object and copy of an object? Compare them.

3 Answers  


Categories