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
- 6740 Views
- HCL, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
What is the query to find nth highest salary? What is the use of cursors?
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
what is Active lock explain
What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?
why we r using presql&postsql in source qualifier?
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
In which scenario did u used Mapping variable?
Which is costliest transformation? costly means occupying more memory?
why union is active transformation?
Teradata 
