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
Tell me about Propagate functions in informatica
How to open an older version of an object in the workspace?
what is the difference between informatica6.1 and infomatica7.1
Define Pmrep command?
What is a rank transform?
Write the prerequisite tasks to achieve the session partition?
How do you set a varible in incremental aggregation
What is source qualifier transformation in informatica?
What is status code in informatica?
Where can we find the throughput option in informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is the difference between informatica 7.0 and 8.0?
What is blocking transformation?
Explain the types of transformations?
where to store informatica rejected data? How to extract the informatica rejected data?