What is aggregate cache in aggregator transforamtion?
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 |
Describe expression transformation?
What are the types of maping in Getting Started Wizard?
What is aggregate awareness?
how the server recognises , if the session fails after loading the 100 records in to the target
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Why use the lookup transformation ?
Enlist few areas or real-time situations where informatica is required.
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?
what is diff between grep and find
4 yrs etl devloper roles and responsibilities?any body give solutions
how many data models u have done in informatica project?