Answer Posted / bsgsr
mappings can be tuned at diff transformations level.
ex; look up can be optimised by enabling the cache.
aggregator can be optimised by using sorted inout.
filter can be optimised by using it as close as possible
to the sql. so on
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Differences between version 7.x and 8.x.
What are the prerequisite tasks to achieve the session partition?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
what is the difference between informatica6.1 and infomatica7.1
Partition, what happens if the specified key range is shorter and longer
What are the popular informatica products?
What is source qualifier transformation in informatica?
Define pmcmd command?
How to generate sequence numbers without using the sequence generator transformation?
What is the difference between a repository server and a powerhouse?
Define mapping and session?
How do you take back up of repository?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Scheduling properties,whats the default (sequential)
Explain what transformation and how many are there in informatica?