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
what is the exact meaning of domain?
Label in Informatica. How to remove existing Label.
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
How many ways are there to do 'remove duplicate records in informatica'?
What is data transformation manager process?
is it possible to index the data in cache of lkp transformation ?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source
What are the types of maping in Getting Started Wizard?
how we load the data from source to staging area