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...

when do we use static cache and when do we use dynamic cache
in lookup transformation? with example.

Answer Posted / swapna

static cache is used when the records in the source does not update more frequently.

dynamic cache is used when the records in the source frequently updates.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the size of your data warehousing?

2042


How do we call shell scripts from informatica?

1011


How to convert multiple rows to single row (multiple columns) in informatica

1316


Enlist the tasks for which source qualifier transformation is used.

980


Describe data concatenation?

1005


Do you find any difficulty while working with flat files as source and target?

1051


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1994


How might one distinguish in the case of mapping is right or not without associating session?

1025


What is the difference between stop and abort in informatica

1042


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2305


Explain why we use partitioning the session in informatica?

1006


What are the issues you have faced in your project? How did you overcome those issues?

2288


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2119


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1926


How can we remove the duplicates from flat file source?

948