what is the main advantage of unconnected lookup
Answer Posted / praveen sh
If the same lookup table is used multiple times in the same
mapping, then it is better to go for un connected lookup.
Doing so we save cache memory and enhence performence
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
In informatics server which files are created during the session rums?
have u done any performance tuning? how u ll do?
What is a surrogate key?
Where is metadata stored?
In how many ways we can create ports?
How to create or import flat file definition in to the warehouse designer?
Differentiate between a repository server and a powerhouse?
How union transformation is used?
can we override a native sql query within informatica? How do we do it?
tell me the rules and responsblites in our project(my project is development)
What is DR strategy for Informatica project?
Define filter transformation?
What is workflow manager?
Could you explain what is enterprise data warehouse?
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