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

Post New Answer

More Informatica Interview Questions

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  


can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,


In which circumstances that informatica server creates Reject files?

2 Answers  


Can you create a flatfile target

3 Answers   ABC,


what is the logic will you implement to load data into a fact table from n dimension tables?

4 Answers   TCS,






What happens if we dont select data driven option?

2 Answers   Zensar,


How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,


How many repositories can we create in Informatica?

3 Answers  


how to design mapping half of source table records into one target and remaining half into another target

8 Answers   ABC,


How we can use union transformation?

0 Answers  


how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

16 Answers   Cap Gemini, IBM,


What aer the out put files that the informatica server creates during the session running?

4 Answers  


Categories