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

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

0 Answers   Bosch,

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

0 Answers  

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,

What is a stored procedure transformation?

0 Answers  

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers   iNautix,

when informatica 8 series released ?

1 Answers   IBM,

What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,

What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  

Diff b/w ShortCut and reusabel Object ?

4 Answers  

For more Informatica Interview Questions Click Here
Categories