in which situations we go for pesistent cache in lookup and
which situations go for shared lookup cache?
Answer Posted / sbvp
1.persistent is session level. it increase the perfomance.
it is useful for mutliple session runs.
2.if we want to lookup on mutli t/r's we go for shared
lookup
thanks
sbvp
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain Dataware house architecture .how data flow from intial to end?
How to load data in informatica ?
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
Explain joiner transformation in informatica
Explain the shared cache and re-cache?
What is rank index in rank transformation?
How to create or import flat file definition in to the warehouse designer?
What is an expression transformation?
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,
What is decode in informatica?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is meant by LDAP users?
What is difference between a gateway node and worker node?
How to handle decimal places while importing a flatfile into informatica?
What are the data movement modes in informatica?