Interested to Buy Any Domain ? << Click Here >> for more details...
How do we implement materialized view?when to use materialized view?
- 1 Answers
- 7774 Views
- TCS, I also Faced
- E-Mail Answers
Answer / chanti
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.
A materialized view can be stored in the same database as its base table(s) or in a different database.
Materialized views stored in the same database as their base tables can improve query performance through query rewrites. Query rewrites are particularly useful in a data warehouse environment.
| Is This Answer Correct ? | 3 Yes | 0 No |
Which files are created during the session rums by informatics server?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
How will u pas the data with out debugger?
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
what is mapping parameter?
Explain the types of transformations?
How many transformations can be used in mapplets.
Explain what are the different types of transformation available in informatica.
Explain the difference between mapping parameter and mapping variable?
What are the limitations of joiner transformation?
What is a node in Informatica?
Teradata 
