Interview Questions

Advanced ETL Interview Questions - If there are ten thousand records in a source system, how do we ensure that all ten thousand are loaded to the target without any dysfunctional values?

ETL (extract, transform, and load) Testing Interview Questions


(Continued from previous question...)

Advanced ETL Interview Questions - If there are ten thousand records in a source system, how do we ensure that all ten thousand are loaded to the target without any dysfunctional values?

The issue here is that with such a large amount of transformed and loaded records, you cannot go through their entirety one by one to confirm their validity. You start by checking the number of records on the source and the target. Create a data type for each. Select the sums and compare the information. This is referred to as a ‘check sum’ method.

(Continued on next question...)

Other Interview Questions