Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 6 Answers
- 14370 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 the cumulative sum of salaries of employees into target table?
Quickly characterize reusable change?
Explain in detail about scd type 1 through mapping.
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
hi real timers . iam waiting for ur reply regarding ETL TESTING
How you prepared reports for OLAP?
Can we override a native sql query within informatica?
waht type of interface is used for testing the data in informatica
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
what is the size ur source like(file system or database)? how many record daily come u r banking project?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is dynamic cache?
What is meant by lookup transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
