what is mapping performence?
Answers were Sorted based on User's Feedback
Answer / vino
Mapping performance is nothing but u tune the mapping to
achieve better performnace .
Like to use filter after sq,using sorter before
aggregator,deleting unwanted fields in the lookup etc.....
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / nafeeja
Mapping Performance is to tune the mapping for better performance. To achieve this first we need to find out the performance bottle necks at three levels and optmise those.
1) Identifying Source Bottlenecks
2) Target bottleneck.
3) Identifying Mapping Bottlenecks
| Is This Answer Correct ? | 0 Yes | 0 No |
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
how do u tune queries?
what is constraint based load order
What is a difference between complete, stop and abort?
How can we create index after completion of load process?
What is rank transform?
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
What are the designer tools for creating tranformations?
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
What could be the possible resons of locks by user?
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)