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

what is parameter file?

1 Answers   Cap Gemini,


How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  


Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  


A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?

4 Answers  


In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,


Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,


What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 Answers  


hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me

3 Answers  


How to load query faster,so that It will take less time to load?

1 Answers   BNP Paribas,


There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,


How do you recover rows from a failed session

1 Answers  


Categories