How do we implement materialized view?when to use materialized view?
- 1 Answers
- 6953 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 |
How many ways are there to create ports?
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
scenario where i can use only concurrent execution of workflow.
What are the types of groups in Router transformation?
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
what is index?how it can work in informatica
Explain why we use partitioning the session in informatica?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
HOW DO YOU PARFORM INCREMENTAL LAOD ?
Performance tuning in UNIX for informatica mappings?
Teradata 
