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 / gm
In This Case We have to do source partion. It means source
may be divided into sevral sources. DBA people will do.
After that create mapping for every source and make it
parralles session. and same target.
================================
Easy To Say: We have to do partion in source.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is a grid in Informatica?
How to elaborate tracing level?
What do you mean by enterprise data warehousing?
What is an active transformation?
What are the new features of informatica 9.x developer?
How many transformations can be used in mapplets.
What is the benefit of partitioning a session?
What are the new features of informatica 9.x at the developer level?
Describe the impact of several join conditions and join order in a joiner transformation?
Write the unconnected lookup syntax and how to return more than one column.
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How you can differentiate between connected lookup and unconnected lookup?
What is the use of source qualifier?
Where do we use mapping variables in informatica?
How to join three sources using joiner?