Chapter 17 Flashcards
1
Q
What is inconsistent representation
A
Data is same but represented in different ways
2
Q
What is group ranking
A
First get data from the table where is more data and then get data from another table when data is missing
3
Q
What is complexity of data transformation
A
Convert data from one form to another.
4
Q
What are 3 types of data transformation
A
- 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)
5
Q
What is open system
A
System that easily available
6
Q
What is web scrapping
A
Web scrapping is data population from web site to dataware house
7
Q
Define ETL vs ELT
A
- Extract Load Transform
- Transform Load Transform
8
Q
Does dataware house server parallel
A
Yes
