Hi,
There is a session in my workflow which is running for a
long time, atlast we found the cause is the missing index.
My session is running via a stored procedure. Can I create
an Index on the table which the stored procedure is using
while my session is running? Please suggest.
My Informatica version is PC 8.0.6
My Oracle APPS is 11.5.3.
Thanks,
No Answer is Posted For this Question
Be the First to Post Answer
Explain grouped cross tab?
why we use source qualifier transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is Collect performance data in informatica and what is the use of it.
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is sq transformation?
What are the popular informatica products?
What are the active and passive transforamtions?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is the difference between stop and abort in informatica
How to elaborate powercenter integration service?
What is the functionality of update strategy?