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
where to store informatica rejected data?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
is it possible to index the data in cache of lkp transformation ?
Where are the source flat files kept before running the session?
What are the differences between oltp and olap?
On which transformations you created partitions in your project?
Explain in detail about scd type 1 through mapping.
What is the procedure for creating independent data marts from informatica 7.1?
How can we use mapping variables in informatica? Where do we use them?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How to update or delete the rows in a target, which do not have key fields?
Why is sorter an active transformation?
What do you understand by SOA of Informatica?
What is primary and backup node?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.