Explain the use of data profiling

It is very important to analyze the source data before proceeding with tasks. In SISS, we can analyze and organize the given data. This is called data profiling. There is a list of steps followed in data profiling. It includes identifying and cleaning the data, finding the number of true value and null values, etc. This gives a better understanding of the source data and is helpful in creating the database destination design schema. This is usually done at the beginning of the project. This gives an idea on how to proceed with the project and how long will it take to complete.