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,
- 0 Answers
- 7116 Views
- HCL, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the challenges of Dataware housing in the future?
waht is dataware house
What does cheating measurement mean?
How to convert flat file into xml file? How to tune joiner?
What is the difference between stop and abort in informatica
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
what is the size of u r source(like file or table)?
Enlist some properties of sessions.
What are the different types of schemas?
Teradata 
