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 |
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
How many types of sessions are there in informatica.please explain them?
Explain grouped cross tab?
How to display null values on a target & non-null values on a target?
How the dimensions will be loaded?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
What is a passive transformation?
What are the join types in joiner transformation?
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
When will you use SQL override in a lookup transformation?
what is data driven in update strategy transformation?
In Which scenario did u used Incremental loading?