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 factless fact schema?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
What are the new features of informatica 9.x developer?
how can we load starting with 11th record of a table from source to target
what is the complex transformation you used in informatica
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Explain Dataware house architecture .how data flow from intial to end?
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?
Explain the different kinds of facts.
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
4 yrs etl devloper roles and responsibilities?any body give solutions