Interested to Buy Any Domain ? << Click Here >> for more details...
How can yoU improve session performance in aggregator
transformation?
- 8 Answers
- 27675 Views
- TCS, I also Faced
- E-Mail Answers
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
What if the source is a flat-file?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is meant by pre and post session shell command?
What is a predefined event?
What are the advantages of informatica?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are batches?
How identifying bottlenecks in various components of informatica and resolving them?
What are the different transaction levels available in transaction control transformation?
How to update a particular record in target with out running whole workflow?
How to load data in informatica ?
can u any challenge your project?
what is the size of your data warehousing?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is informatica worklet?
