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
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?
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
When you move from devel to prod how will you retain a variable
What is meant by active and passive transformation?
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?
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
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?
What are set operators in Oracle
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
What are the options in the target session of update strategy transsformatioin?
Global and Local shortcuts. Advantages.
How to generate sequence numbers using expression transformation?