What is the purpose of data profiling in the data migration system?

This is another operational question by which the interviewer is trying to determine your knowledge of this particular operation within the data migration process. You should be able to answer these types of questions easily based on your experience in this area. It is always advisable to brush up on the fundamentals in your field before an interview.

"Data profiling is a careful examination of the scope, quality, and content of a data source to enable a data migration system to be built. Its purpose is to verify that the data source has been well maintained before it is migrated to the data warehouse. If done effectively, the data will require minimal transformation and human intervention to load directly into the tables of the data warehouse."