What is ?Data Warehousing??

Answer Posted / bhaskar.nagi

A Data Warehouse is a type of Relational Data Base,
Specially designed for Query and Analytical processing
rather than for transactional processing.

A DWH is a

Time Variant
Non-Volatile
Subject Oriented
Integrated Data Base.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many project sources we can create in metadata?

561


Is union transormation is active transformation?

591


Explain the main differences between star and snowflake schema?

546


What is the difference between dependent data warehouse and independent data warehouse?

607


Explain are data mart and dwh normalized or denormalized? Do both of them exist in

596






Explain me what is vldb?

527


How can we do data cleaning?

588


Give some difference between oltp and olap.

597


What is scd1 , scd2 , scd3?

682


Explain the main difference between inmon and kimball philosophies of data warehousing?

554


Explain what are the different methods of loading dimension tables?

510


How to create different types of templates?

521


How to test report in reportnet?

570


What are data validation strategies for data mart validation after loading process?

539


What is data type of the surrogate key?

617