If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
Answer Posted / vivek
I think before sending
data from the source if we
sort the data by sql
override i.e by adding a
"order by" clause in
default sql querry then
our problem wil be solved.
Is This Answer Correct ? | 0 Yes | 12 No |
Post New Answer View All Answers
What is expression transformation?
Name the different lookup cache(s)?
Explain joiner transformation in informatica
What do you mean by worklet?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain the mapping variable usage example in informatica
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is dimensional table?
How can we remove the duplicates from flat file source?
scenario where i can use only concurrent execution of workflow.
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,
What is the commit type if you have a transaction control transformation in the mapping?
What is native users?
Where do we use mapping variables in informatica?