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
- 5940 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 |
wf dont have integration severances how you can run?
Sequence generator, when you move from develoment to production how will you reset
Explain transaction control transformation in informatica
how i will stop my workflow after 10 errors
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,
how many types transformations supported by sortedinput?
Define enterprise data warehousing?
What is Code Page Compatibility?
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com
Teradata 
