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
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?
How can we improve session performance in aggregator transformation?
What is a surrogate key?
How to join three sources using joiner? Explain though mapping flow.
State the differences between sql override and lookup override?
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,
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
In development project what is the process to follow for an etl developer from day1
What are the different transaction levels available in transaction control transformation?
How can you increase the performance in joiner transformation?
How can we delete duplicate rows from flat files?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is repository manager?
Explain the informatica workflow?
How do you set a varible in incremental aggregation