Interested to Buy Any Domain ? << Click Here >> for more details...
what is mapping optimization? wat are the techniques for tat
- 2 Answers
- 7809 Views
- I also Faced
- E-Mail Answers
Answer Posted / satya
*Use sorted input in Aggretator transformation to decrease
the use of aggregate caches.If you use a Filter
transformation in the mapping, place the transformation
before the Aggregator transformation to reduce unnecessary
aggregation.
* We can use the Source Qualifier transformation to filter
as an alternate way to filter rows.
* Perform joins in a database when possible rather using a
joiner transform
*Adding an index to the columns used in a lookup condition
if you have privileges to modify the database containing a
lookup tables.
these are some simple techniques
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain how many types of dimensions are available in informatica?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Scheduling properties,whats the default (sequential)
What is the difference between stop and abort in informatica
What are the main issues while working with flat files as source and as targets ?
What is a sequence generator transformation?
What are the tuning techniques you applied during your last project
Can u generate reports in Informatica?
What is dynamic cache?
What is the meaning of up gradation of repository?
What are the prerequisite tasks to achieve the session partition?
What are the different transaction levels available in transaction control transformation?
Explain the types of transformations?
What are different types of transformations available in informatica?
