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

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,

what are the Methods For Creating Reusable Transformations?

0 Answers   Informatica,

any body can say about all versions of informatica ?how many versions ?

2 Answers  

1 lac of flat fles in source how to load target at a time?

4 Answers   Cap Gemini,

What is meant by target load plan?

0 Answers  

Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

3 Answers   Cap Gemini, Puma, Wipro,

what is the gap analysis?

1 Answers  

Briefly define a session task?

0 Answers  

Informatica settings are available in which file?

0 Answers   Informatica,

how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  

For more Informatica Interview Questions Click Here
Categories