In the ETL process, one important step to process when transforming the data is to work with

Question:

In the ETL process, one important step to process when transforming the data is to work with NULL, N/A, and zero values in the dataset. If you have a field of quantitative data (e.g., number of years each individual in the table has held a full-time job), what would be the effect of the following?
a. Transforming NULL and N/A values into blanks
b. Transforming NULL and N/A values into zeroes
c. Deleting records that have NULL and N/A values from your dataset

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  answer-question

Data Analytics for Accounting

ISBN: 978-1260375190

1st edition

Authors: Vernon Richardson

Question Posted: