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
How to Create a folder using pmrep command?
COM components can be used in Informatica
What is meant by LDAP users?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How to elaborate tracing level?
What is the difference between informatica 7.0 and 8.0?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is depict expression change?
What are the mapping parameters and mapping variables?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is deployment group?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What are the measure objects?
To import the flat file definition into the designer where should the flat file be placed?