Data Warehousing Questions

Q:

What is Data Integration?

Answer

- The process of combining data from different resources.


- The combined data is provided to the users with unified view.


- Information from different enterprise domains are integrated – known as Enterprise Information Integration.


- Useful for merging information from different technologies among enterprises.


- The sub areas of data integration are 


1. Data Warehousing.


2. Data Migration.


3. Master Data Management.

Report Error

View answer Workspace Report Error Discuss

0 855
Q:

Define "Correlated Subqueries" ?

Answer

In a SQL Database, a 'correlated subquery' is a kind of sub query yet connected subquery is dependent on another query for a value that is returned. In case of execution, the sub query is executed first and afterwards the correlated query will be executed.

Report Error

View answer Workspace Report Error Discuss

6 850
Q:

Which of the following is not a function of a Warehouse?

A) Ensuring Profit B) Stabilisation in price
C) Risk-bearing D) Storage
 
Answer & Explanation Answer: A) Ensuring Profit

Explanation:
Report Error

View Answer Report Error Discuss

0 530