What is ?Data Warehousing??
Answers were Sorted based on User's Feedback
Answer / ravi v
It is a database, which process of the data extraction from
different sources and translate the data into required
format and load that into the data warehouse is called Data
Warehousing.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / shekar
Data ware house is type of a realation database,design for
query and anlytical reports. It is subject Orentend non
volatile ,integreted of collection of data in support of
management desicon making porocess
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
What is the goal of optimizer?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is the difference between a data warehouse and a data mart?
15 Answers Apex, ASD Lab, Bank Of America,
Why null values are mapped as 0 in fact tables?
Explain what is analytical or analytic mean?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain Process flow in data warehouse??
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What is a Data Cube?
What is a Data Warehouse?
Fact table is in normalized or de-normalized form?
How can we run the graph?