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

Answer Posted / sehaj

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is informatica etl tool?

769


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

831


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

779


Explain why we use partitioning the session in informatica?

831


How many ways are there to do 'remove duplicate records in informatica'?

808


Is there any way to read the ms excel datas directly into informatica?

791


Differentiate between a database and data warehouse?

925


What is an unconnected transformation?

883


What are the types of lookup transformation?

873


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1999


Does an informatica transformation support only aggregate expressions?

834


can u any challenge your project?

1823


How do you take back up of repository?

943


Can we create two repositories on same database instance in oracle?

871


What is workflow manager?

808