What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Two different admin users created for repository are________and_________.
When do we go for the tools in the market?
what is different between sequential batch and concurrent batch and which is recommended and why?
what is an ETL or ETT? And what are the different types?
what is the advantage of persistent cache? when it should be used?
What is tracing level and what are the types?
what are the different Reporting and ETL tools available in the market?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
tell me few points when u become TL
what is Forward,Reverse and Re_engineering?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?