Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56006 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answer Posted / harshakore
A view has a logical existence but a materialized view has
a physical existence.Moreover a materialized view can be
indexed,analysed and so on....that is all the things that
we can do with a table can also be done with a materialized
view.
| Is This Answer Correct ? | 110 Yes | 5 No |
Post New Answer View All Answers
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How can you validate all mappings in the repository simultaneously?
Can you use flat files in Mapplets.
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
In development project what is the process to follow for an etl developer from day1
What is the Rank index port in Rank transformation?
Explain the difference between mapping parameter and mapping variable?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is the difference between writing a joiner query in ANSI style and THETA style?
What is Index Caches size?
Is there any target staging area in informatica not staging area
Define Pmrep command?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Performance tuning in UNIX for informatica mappings?
