Whatis the difference between View and Materialized View ?
Answer Posted / roshan
apart from all the above answer one more difference is:
suppose we delete a table then all the views becomes invalid but this is not the case with the materialized view. its most interesting feature is auto commit refresh...
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is the difference between writing a joiner query in ANSI style and THETA style?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How to use procedural logic inside infromatica?
Define pmcmd command?
How do you change a non-reusable transformation to reusable transformation?
What is DR strategy for Informatica project?
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 substr in informatica?
What is workflow manager?
how to load rows into fact table in data warehouse
What happens when a session fails and you click on recover?
explan ur project architecture?
What does command task mean?