Answer Posted / shruthi
Materialized views are schema objects that can be used to
summarize, precompute, replicate, and distribute data. E.g.
to construct a data warehouse.
A materialized view provides indirect access to table data
by storing the results of a query in a separate schema
object. Unlike an ordinary view, which does not take up any
storage space or contain any data.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How do you load only null records into target? Explain through mapping flow.
generate date / time dimension in informatica
In informatics server which files are created during the session rums?
Briefly define reusable transformation?
Name the different lookup cache(s)?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are the different options available for update strategy?
What happens when a session fails and you click on recover?
tell me 5 session failure in real time how can you solve that in your project?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is an expression transformation in informatica?
What are the differences between source qualifier and joiner transformation?
What do you understand by term role-playing dimension?
What are data-driven sessions?
Describe data concatenation?
