Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 6 Answers
- 14471 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
what is Active lock explain
lookup transformation with screenshots
What are the designer tools for creating transformations?
How many transformations can be used in mapplets.
What is workflow? What are the components of the workflow manager?
What is joiner transformation in informatica?
What is meant by target load plan?
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
How can you validate all mappings in the repository simultaneously?
Parameter and variable differences
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Mention some types of transformation?
Slowly changing dimensions, types and where will you use them
How do you handle two sessions in Informatica
In informatica workflow manager, how many repositories can be created?
