Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mike
Well in simple terms
A meterialized view is a view that contains data in some
temporary tables. If we consider the view at database level
it only stores the query , when ever we call the view it
extracts the data from the database based on the query...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What does command task mean?
Have you worked with/created Parameter file
What is the difference between informatics 7x and 8x and what is latest version?
Enlist the various types of transformations.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is the function of aggregator transformation?
What is workflow monitor?
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.
can u any challenge your project?
without table how to come first record only in oracle?
write a query to retrieve the latest records from the table sorted by version(scd)
Whats there in global repository
What could be the possible resons of locks by user?
Explian the Process of deployment groups in informatica
Differentiate between a database and data warehouse?
