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
What is sq transformation?
How to improve the performance of a session using sorter transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
4 yrs etl devloper roles and responsibilities?any body give solutions
Differentiate between reusable transformation and mapplet.
How can you define user defied event?
What do you mean incremental aggregation?
What is incremental aggregation?
What are some examples of informatica etl programs?
What is the maplet?
how many types of dimensions are available in informatica?
differences between service based and product based?
how we can load rejected record's at run time?(not through bad files)
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a node in Informatica?