suppose we are using dynamic lookup cache and in lookup
condition the record is succeeded but in target it is failed
due to some reasons then what happened in the cache ?
Answer Posted / urs
When we are using the lookup cache as dynamic at first run
it will stores the all lookup table records into the cache
but second run it will check whether the incoming source
record having in the target table or not..if the record
exist in target table it will update otherwise it will
insert..this load type is done based on your condition
...nothing will happen in cache..
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain constraint based loading in informatica
update strategy transformation in informatica
how we can load rejected record's at run time?(not through bad files)
Performance tuning( what you did in performance tuning)
What is the use of an aggregator cache file?
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
What is option by which we can run all the sessions in a batch simultaneously?
can we override a native sql query within informatica? How do we do it?
Name the different lookup cache(s)?
What are the different versions of informatica?
Do you find any difficulty while working with flat files as source and target?
lookup transformation with screenshots
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is target load order?
How can informatica be used for an organization?