Interested to Buy Any Domain ? << Click Here >> for more details...
How can yoU improve session performance in aggregator
transformation?
- 8 Answers
- 27403 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 InformaticaPowerCenter?
Where do we use mapping variables in informatica?
Describe expression transformation?
What are active and passive transformations?
What is a repository manager?
where to store informatica rejected data?
When do you use sql override in a lookup transformation?
Different sorts of metadata that stores in the storage facility?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
what is mean by complex business rule ?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What does update strategy mean, and what are the different option of it?
How to partition the Session?
What are the static cache and dynamic cache in informatica?
