How can yoU improve session performance in aggregator
transformation?
Answer Posted / sasmita panda
session performance in aggregator T/R can be increased by
aggregation cache i.e through increamental aggregation.
Aggregation cache has tow caches i)index ii) data.
For first run it performs aggregation calculation in
aggregation cache.Index cache contains group by port
values.Data cache will contain if any variable ports are
created and output port on which we want to implement
aggregate function.
Rowid of last record which is participated in Agg. T/R will
be saved in repository.
During second run it finds the rowid of last record then it
performs increamental aggregation.The integration service
will check the historical information in the index cache
file for corresponding group.If it finds it performs
aggregation operation increamentally. If not finds then it
will adda new port for aggreagtion.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
tell me 5 session failure in real time how can you solve that in your project?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
what is Active lock explain
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain pushdown optimization and types in informatica
Can informatica load heterogeneous targets from heterogeneous sources?
What is expression transformation?
What all are steps in up gradation of Informatica server?
What are the features of complex mapping?
What is the meaning of up gradation of repository?
How to handle decimal places while importing a flatfile into informatica?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is repository manager?
What are the new features of informatica 9.x in developer level?
What are the tasks that can be performed using sq?