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 a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Explian the connected and unconnected lookup transformation
How to open an older version of an object in the workspace?
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
explan ur project architecture?
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
Which is costliest transformation? costly means occupying more memory?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
What is log file,and where is it located,why u r using the log file
what are the difference between Informatica 7.1 and 8.1?
where actually the usage of push down optimization happens...
Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)