Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7070 Views
- I also Faced
- E-Mail Answers
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
Can we create two repositories on same database instance in oracle?
Can we change Dynamic to Static or Persistent cache? If so what happens?
can we override a native sql query within informatica? How do we do it?
What all join we can perform in LOOKUP transformation?
Enlist some properties of sessions.
What is target designer and target load order?
Explain the use of aggregator cache file?
Where are the source flat files kept before running the session?
What are the designer tools for creating transformations?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
write a query to retrieve the latest records from the table sorted by version(scd)
Define update strategy?
What is a joiner transformation and why it is an active one?
What is informatica? Why do we need it?
What is a transaction control transformation?
