1. Explain me what is meant by Data Analytics?
Data analytics (DA) is the science of examining raw data with the purpose of drawing conclusions about that information. A data warehouse is often built to enable Data Analytics
2. Explain me what is conformed fact?
Conformed fact is a table which can be used across multiple data marts in combined with the multiple fact tables.
3. Do you know what is called data cleaning?
Name itself implies that it is a self explanatory term. Cleaning of Orphan records, Data breaching business rules, Inconsistent data and missing information in a database.
4. Explain me what is real-time datawarehousing?
Real-time datawarehousing captures the business data whenever it occurs. When there is business activity gets completed, that data will be available in the flow and become available for use instantly.
5. Explain any five applications of data warehouse?
Some applications include:
☛ financial services
☛ banking services
☛ customer goods
☛ retail sectors
☛ controlled manufacturing
6. Explain me what are the key columns in Fact and dimension tables?
Foreign keys of dimension tables are primary keys of entity tables. Foreign keys of fact tables are the primary keys of the dimension tables.
7. Explain what is dimensional modeling?
Dimensional model consists of dimension and fact tables. Fact tables store different transactional measurements and the foreign keys from dimension tables that qualifies the data. The goal of Dimensional model is not to achieve high degree of normalization but to facilitate easy and faster data retrieval.
Ralph Kimball is one of the strongest proponents of this very popular data modeling technique which is often used in many enterprise level data warehouses.
8. Tell me what are Aggregate tables?
Aggregate tables are the tables which contain the existing warehouse data which has been grouped to certain level of dimensions. It is easy to retrieve data from the aggregated tables than the original table which has more number of records.
This table reduces the load in the database server and increases the performance of the query.
9. Explain me what needs to be done when the database is shutdown?
Following needs to be done when the database is shutdown:
☛ Close the database
☛ Dismount the database
☛ Shutdown the Instance
VLDB is abbreviated as Very Large Database and its size is set to be more than one terabyte database. These are decision support systems which is used to server large number of users.
