what is shared Cache. when we will use shared Cache?

Answer Posted / rao

shared cache is a one of the lookup caches of a lookup
transformation.
if we choose this option Informatica server creates the
cache memory for multiple lookup transformations in the mapping.
when first lookup transformation function completed then
memory is released and use that memory used by the other
look up transformation.

Is This Answer Correct ?    12 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1632


How can we improve session performance in aggregator transformation?

796


What is a surrogate key?

718


How to join three sources using joiner? Explain though mapping flow.

813


State the differences between sql override and lookup override?

768






Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6874


HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1830


In development project what is the process to follow for an etl developer from day1

1401


What are the different transaction levels available in transaction control transformation?

802


How can you increase the performance in joiner transformation?

837


How can we delete duplicate rows from flat files?

883


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

817


What is repository manager?

660


Explain the informatica workflow?

726


How do you set a varible in incremental aggregation

1580