Questions

1. What is the best way to handle missing values?
   In this case, the best thing is to remove a whole column or row. However, this can lead to a significant loss of information. For this reason, other methods are used, such as replacing missing value with the mean, mode, or median. We can also use custom values and more sophisticated methods for missing-value imputation, including the mean of closest neighbors or linear regression.
2. Why do we normalize data?
   We do this because we need to rescale data to be more comparable.
3. Which editions of SQL Server contain SSIS?
   SQL Server from 2005 until now, Enterprise, and Standard Editions.

4. Which components of the SSIS package execute the data transformation?
   The data transformation starts in a control-flow task called Data Flow Task. Internally, the Data Flow Task causes the data-flow engine to start and execute the data transformation...