Interested to Buy Any Domain ? << Click Here >> for more details...
How can yoU improve session performance in aggregator
transformation?
- 8 Answers
- 27324 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 is the function of aggregator transformation?
Can you use flat files in Mapplets.
Does an informatica transformation support only aggregate expressions?
Which transformation should we use to normalise the COBOL and relational sources?
What is union transformation?
How many types of sessions are there in informatica.please explain them?
whats the logic to load the lower level of granularity of data to fact table.
What is rank index in rank transformation?
Make a note of the quantity vaults made in informatica?
What is the use of source qualifier?
What is a repository manager?
How do you promote a non-reusable transformation to reusable transformation?
What is DR strategy for Informatica project?
What can we do to improve the performance of informatica aggregator transformation?
What do you understand by a term domain?
