what is the max/min size allocated for caches.whether index
or datacache in any of the transformations like Joiner or
Aggregator.bcoz it is set to Auto by default which means we
need not to allocate no of bytes or MB.so what is the use of
these properties.please let me know about the caches.
Thnaks in advance
Sai Ram
- 3 Answers
- 6460 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srinivas bolusupati
Data cache size is between 2MB to 24MB.
Index cache size is between 1MB to 12 MB.
| Is This Answer Correct ? | 3 Yes | 0 No |
INDEX CACHE IS MIN IN SIZE AND DATA CACHE IS MAX IN SIZE
| Is This Answer Correct ? | 0 Yes | 0 No |
MIN SIZE FOR INDEX CACHE IS 1MB
N DAT OF DATA CACHE IS DOUBLE OF THAT
IN AGGREGATOR..THE AUTO PROPERTY PERFORMS THE FOLLOWING
FUNCTION...
SUPPOSE WE HAVE CHOOSED THE SIZE TO BE 8 MB N THE SESSION
UTILIZES ONLY 3 MB SO IF WE SET THE PROPERTY TO AUTO IT WILL
SET THE CACHE SIZE AUTOMATICALLY TO 3MB.
| Is This Answer Correct ? | 0 Yes | 0 No |
How can you differentiate between powercenter and power map?
What is target load order?
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
What is a command that used to run a batch?
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
How to fix the etl bugs..Tell me the process?
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
In operator is used in which transformation in informatica 8.6.0
What is olap (on-line analytical processing?
In joiner, how to load Master table in Target?
How to view and Generate Metadata Reports?
What is mapplet in informatica?
Teradata 
