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 |
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
What are the advantages of informatica?
Can we create a Integration service without a Repository service and vice versa?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How many ways are there to do 'remove duplicate records in informatica'?
What is hash partition?
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
In which transformation you cannot drag ports into it?
What are the uses of a Parameter file?
two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .
How to load a Dimension ? and how to load a fact table?