- Physical Data Integration is all about creating new system that replicates data from the source systems.
- This process is done to manage the data independent of the original system.
- Data Warehouse is the example of Physical Data Integration.
- The benefits of PDI include data version management, combination of data from various sources, like mainframes, flat files, databases.
- A separate system is needed for handling vast data volumes.
Explain Is OLAP databases are called decision support system true/false?
Explain What is the difference between datawarehouse and BI?
What is the difference between ODS and OLTP?
What is active data warehousing?
What is the difference between datawarehouse and BI?
Where the applications and where ware house management system is used?
What is snapshot?
Please explain in detail about type 1, type 2(SCD), type 3?
Explain what is aggregate table and aggregate fact table ... any examples of both?
Explain What is fact less fact table? where you have used it in your project?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
