Chapter 17

Question 1

What is inconsistent representation

Answer 1

Data is same but represented in different ways

Question 2

What is group ranking

Answer 2

First get data from the table where is more data and then get data from another table when data is missing

Question 3

What is complexity of data transformation

Answer 3

Convert data from one form to another.

Question 4

What are 3 types of data transformation

Answer 4

• Single/one to one (e.g. replace address fields to make a standard)
• Complex/One to many (e.g. one address convert to many fields)
• many to many (multiple people of multiple families living on one home)

Question 5

What is open system

Answer 5

System that easily available

Question 6

What is web scrapping

Answer 6

Web scrapping is data population from web site to dataware house

Question 7

Define ETL vs ELT

Answer 7

• Extract Load Transform

- Transform Load Transform

Question 8

Does dataware house server parallel

Answer 8

Yes