How many approaches are there in data warehousing to integrate heterogeneous databases?

5

4

3

2

ETL stands for

Effect, transfer, and load

Explain, transfer and load

Extract, transfer, and load

Extract, transform, and load

Identify the type of relationship between fact and dimension table in a star schema.

One to one

Many to many

One to many

Many to one

What is the use of data cleaning?

To remove the noisy data

Transformations to correct the wrong data.

Correct the inconsistencies in data

All of the above

What does OLTP stand for? Offline transaction processing

Online transaction processing

Outline traffic processing

None

is an object-oriented, integrated, time-variant, and nonvolatile collection of data in support of management decisions.

Data warehousing

Data mining

Web mining

Text mining

The data is stored, retrieved and updated in .

SMTP

FTP

OLAP

OLTP