Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / sai ram

Answers were Sorted based on User's Feedback



what is the max/min size allocated for caches.whether index or datacache in any of the transformat..

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

what is the max/min size allocated for caches.whether index or datacache in any of the transformat..

Answer / venkateshmalneni

INDEX CACHE IS MIN IN SIZE AND DATA CACHE IS MAX IN SIZE

Is This Answer Correct ?    0 Yes 0 No

what is the max/min size allocated for caches.whether index or datacache in any of the transformat..

Answer / 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

More Informatica Interview Questions

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,

how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

3 Answers   CTS,

What is the default join that source qualifier provides?

3 Answers   Informatica,

Performance tuning( what you did in performance tuning)

0 Answers   Infosys,

how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

16 Answers   Cap Gemini, IBM,

What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  

Explain what are the different types of transformation available in informatica.

0 Answers  

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers   Cap Gemini, IBM,

what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,

What is confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,

What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  

For more Informatica Interview Questions Click Here
Categories