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

star and snowflake schema?

6 Answers  


What is mapplet in informatica?

0 Answers  


How the facts will be loaded? explain

2 Answers   HCL,


Can we have a Mapping without a Source Qualifier?

14 Answers   Deloitte,


What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

15 Answers   Deloitte,






My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,


i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,


how can we perform incremental aggregation?explain with example?

9 Answers   IBM, TCS,


Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,


Two different admin users created for repository are ______ and_______

1 Answers  


In Which scenario did u used Incremental loading?

2 Answers  


what is normalizer transformation?

4 Answers   Wipro,


Categories