Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 6 Answers
- 14645 Views
- I also Faced
- E-Mail Answers
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
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the types of caches in lookup? Explain them.
Explain the code page compatibility?
What do mean by local and global repository?
explain about unit testing? in real time?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the prerequisite tasks to achieve the session partition?
What are different types of transformations available in informatica?
Can anyone tell me the new features in Informatica 9 Version?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What does role playing dimension mean?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is the benefit of session partitioning?
Explain the different lookup methods used in informatica?
tell me 5 session failure in real time how can you solve that in your project?
