Answer Posted / vdrona
Mapping can be tuned by identifying the following bottlenecks in order shown below.
1. Target Bottlenecks
2. Source Bottlenecks
3. Transformation/Mapping Bottlenecks
4. Session Bottlenecks
5. System Bottlenecks
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What are the new features of Power Center 5.0?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is the difference between a repository server and a powerhouse?
Define pmcmd command?
What is the procedure for creating independent data marts from informatica 7.1?
r u done any partitions in ur project?
Separate from a database, an information bazaar, and an information stockroom?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is enterprise data warehousing?
How to start a workflow using pmcmd command?
What is lookup transformation?
How are indexes created after completing the load process?
To import the flat file definition into the designer where should the flat file be placed?
What is deployment group?
Which means the first record should come as last record and last record should come as first record and load into the target file?