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
What is data transformation manager process?
What do you understand by a term domain?
what is the Default Source Option For Update Strategy Transformation?
State the differences between sql override and lookup override?
Did u used latest transformations of 8.6.0? for what?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Explain lookup transformation source types in informatica
To import the flat file definition into the designer where should the flat file be placed?
Can we get 1st record through Informatica(without sequence number).
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How is union transformation utilized?
Plz can any one say me how to get the informatica certification materials and dumps
What are different types of transformations available in informatica?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
how tokens will generate?