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
can any one explain me about junk dimension
What are the basic needs to join two sources in a source qualifier?
How to get EVEN & ODD numbers separately?
What is session task and command task?
What are the different types of code pages available in informatica & how to implement it in your project?
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?
what is degenerated dimension
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)