Hi can any one tell me the difference between persistence
and dynamic caches? On which conditions we are using these
caches?
Answer Posted / dl
few more additions to the above answer.....
1.Dynamic lookup allows to modify cache where as
persistentlookup does not allow us to modify cache.
2.Dynamic lookup use 'newlookup row', a default port in the
cache but persistent does use any default ports in cache.
3.As session completes dynamic cache removed but the
persistent cache saved in informatica power centre server.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
how we can load rejected record's at run time?(not through bad files)
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
Partition, what happens if the specified key range is shorter and longer
What is data caches/ index caches?
What is the maplet?
Under what condition selecting sorted input in aggregator may fail the session?
Explain dynamic target flat file name generation in informatica
what is degenerated dimension?
Clarify the utilization of aggregator cache record?
Can you generate sequence numbers without using the sequence generator transformation?
Differentiate between a repository server and a powerhouse?
What is meant by pre and post session shell command?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.