download the server access log file
The server access log file contains these fields
a. timestamp - TIMESTAMP
b. latitude - float
c. longitude - float
d. visitorid - char(37)
e. accessed_from_mobile - boolean
f. browser_code - int
The extract task extract the fields timestamp and visitorid
The transform task capitalize the visitorid
The load task compress the extracted and transformed data.
- download
- extract
- transform
- load