Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 6 Answers
- 14629 Views
- I also Faced
- E-Mail Answers
Answer Posted / deepika
a view is like window through which we can acess the data.
it doesnot store the data,where as materialized view can
contain data also.this can be used for pre computed complex
calulations.
materialized views are called snapshots before oracle 9i
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Design a mapping to load a target table with the following values from the above source?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How to create Target definition for flat files?
Explain constraint based loading in informatica
Design a mapping to load the cumulative sum of salaries of employees into target table?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What happens when a session fails and you click on recover?
define galaxy repository in informatica
generate date / time dimension in informatica
What is rank transformation in informatica
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is DR strategy for Informatica project?
How can you differentiate between powercenter and power map?
Explain lookup transformation source types in informatica
