What is the difference between view and materialised view?
Answer Posted / msb.dwh
a view is virtual or logical table it doesnot contain any
data but,m.view haveing data it also act like table m.view
mainly used for replication,computation,mentanience and
distrubuting the data these are equl to table or partation
table wich work like indexs
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How will the document be delivered to me?
What is meant by pre and post session shell command?
Can we create multiple integration service on single repository?
Explain how many types of dimensions are available in informatica?
which one is better performance wise joiner or look up
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Why union transformation is an active transformation?
How to configure mapping in informatica?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain about Informatica server process that how it works relates to mapping variables?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is the procedure for creating independent data marts from informatica 7.1?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.