What is the difference between view and materialised view?
Answer Posted / sarvesh
VIEW IS THE VIRTTUAL TABLE,AND WE CANOT REFRESH THE
DATA ,BUT IN MATERIALISED VIEW WE CAN REFRESH THE DATA
FREQUNENTLY,AND BY USING M.VIEW THE PERFORMANCE WILL BE
INCREASED.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Explain joiner transformation in informatica
Why union transformation is an active transformation?
What is informatica powercenter repository?
Explain your project of banking domian.
What are the different types of olap? Give an example?
Under which circumstances, informatica server creates reject files?
Mention few advantages of router transformation over filter transformation.
What is the benefit of session partitioning?
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
Is there any way to read the ms excel datas directly into informatica?
differences between service based and product based?
What all join we can perform in LOOKUP transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the different ways to implement parallel processing in informatica?