You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance
You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort
You need to ensure that the project is deployed to the production environment with the least amount of administrative effort
You need to establish the best technique to log these invalid rows while minimizing the amount of development effort