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 are the types of schemas we have in data warehouse.
Separate from a database, an information bazaar, and an information stockroom?
How you know when to use a static cache and dynamic cache in lookup transformation?
How can you validate all mappings in the repository simultaneously?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is the different lookup cache(s)?
What are the components of Informatica? And what is the purpose of each?
Where is metadata stored?
What is main use of mapplet?
how to create user defined function (udf) in informatica
How to delete duplicate row using informatica?
How to use pmcmd utility command?
What are the guidelines to be followed while using union transformation?
How do you load first and last records into target table?
What are the new features of informatica 9.x at the developer level?