Interested to Buy Any Domain ? << Click Here >> for more details...
How do we implement materialized view?when to use materialized view?
- 1 Answers
- 7802 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 can we run workflow with pmcmd?
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
What is version control in informatica ? Advance thanks
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
While importing the relational source defintion from database,what are the meta data of source U import?
How to handle changing source file counts in a mapping?
Explain direct and indirect flat file loading (source file type) - informatica
How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?
1 Answers Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,
What does “tail –f” command do and what is its use as an Informatica admin.
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
What is mapplet and a reusable transformation?
Teradata 
