What is aggregate cache in aggregator transforamtion?
- 5 Answers
- 8593 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ravi sadanand
It is place where all the rows entering the Aggregator
Transformation will be placed till the aggregate
calculations like sum,Avg are made.
all the group information will be stored in index files and
row data in data cache.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / saradhi
aggregate cache is used to aggregate the data for that we
are using data cache.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / amedela chandra sekhar
unsorted data loading into aggregate cache.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / ram kumar
Cache is used to increase the performance of the mapping.
There r 2-typs of cache: Data & Index Cache
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / saradhi
In aggrefate cache we have 2 types of caches are there
1) Index
2) Data
Index cahce data is used for sorting purpose.
data is used for storing the data.
| Is This Answer Correct ? | 0 Yes | 2 No |
What are the reusable transformations?
Explain factlessfact table with scenario
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
What is the Process to creating lookup transformation in informatica
How to start a workflow using pmcmd command?
Define informatica repository?
What are the types of presistent cache in look up tr.
what is the predefined port in dynamic lookup
Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
What are the performance considerations when working with aggregator transformation?
Teradata 
