What is the purpose of data profiling in the data migration system?
"Data profiling is the process used to verify that the data being imported into the warehouse is clean, formatted properly, and the correct information the administrator is anticipating. The purpose of data profiling is to minimize and the edits, data manipulation, or human interaction with the data after it has been migrated into the data warehouse."
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."
