Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

0 Answers  


tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

1 Answers  


When you move from devel to prod how will you retain a variable

1 Answers  


What is meant by active and passive transformation?

0 Answers  


My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

3 Answers   Cap Gemini,


if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,


1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,


What are set operators in Oracle

3 Answers   Deloitte, Wipro,


when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  


What are the options in the target session of update strategy transsformatioin?

2 Answers  


Global and Local shortcuts. Advantages.

0 Answers  


How to generate sequence numbers using expression transformation?

0 Answers   Informatica,


Categories