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 different between the data warehouse and data mart?
How do you use reject loader.
What is a transaction control transformation?
Explain pushdown optimization and types in informatica
What is workflow? What are the components of the workflow manager?
How do you handle two sessions in Informatica
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is the sequence generator transformation in informatica?
Under what condition selecting sorted input in aggregator may fail the session?
Write the different tools in the workflow manager?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How many number of sessions can one group in batches?
Define mapping and session?
What are the prerequisite tasks to achieve the session partition?