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

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2111


Do you find any difficulty while working with flat files as source and target?

890


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2542


How can you validate all mappings in the repository simultaneously?

1046


Explain the features of connected and unconnected lookup.

735


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1061


Define Pmrep command?

836


Why sorter is an active transformation?

962


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

846


What is informatica etl tool?

751


what is the size of u r source(like file or table)?

2023


What are the transformations that are not supported in mapplet?

793


What does update strategy mean, and what are the different option of it?

854


Why is sorter an active transformation?

882


How to update a particular record in target with out running whole workflow?

1368