Interested to Buy Any Domain ? << Click Here >> for more details...
What is aggregate cache in aggregator transforamtion?
- 5 Answers
- 9764 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 is informatica etl tool?
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
8.what is mapplet ?give example?
how do the project develops? pls specify right from the start to end in step by steps.
Tell me about MD5 functions in informatica
why sequence generator should not directly connected to joiner transformation ?
What is the status code?
What are the different types of Type2 dimension maping?
If the records doesnt satisfy the filter condition where will it go?
in which situations do u go for sequence generator ?
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
what are types of dimentions?
Teradata 
