what is the diff b/w cached and unchaed look ups
Answer Posted / mike
well
Cached Lookup: In a lookup cache the entire rows will be
put in the buffer and then will be compared with the in
coming rows
where as
uncached lookup: In the uncahed lookup for every row the
lookup will query the lookup table to get the rows
correct me if i was wrong
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
where to store informatica rejected data? How to extract the informatica rejected data?
explain one complex mapping with logic? sales project?
What is target load order?
What do you understand by SOA of Informatica?
Briefly define a session task?
What is the procedure for creating independent data marts from informatica 7.1?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What the difference is between a database, a data warehouse and a data mart?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How can a transformation be made reusable?
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
Performance tuning( what you did in performance tuning)
Which transformation should we use to normalise the COBOL and relational sources?
What is dimensional table?
Explain the types of transformations?