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
- 7182 Views
- HCL, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
how many session run unix environment what command using ?
enterprise datawarehouse your project phase by phase explain?
what are the settiings that u use to cofigure the joiner transformation?
Filter transformation in the condition one of the data is NULL would the record be dropped.
What is the difference between STOP and ABORT options in Workflow Monitor?
What can we do to improve the performance of informatica aggregator transformation?
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
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?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
What is an incremental loading? in which situations we will use incremental loading
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
Teradata 
