- Create a script for checking of data needed to extract
- Modify the Pentaho jobs and ktr for extraction of data
- re-Modify the Pentaho jobs and ktr for extraction of data to apply the three layer (extract,denorm,generation) on the job
- Execute the job for extraction of data and  check if the data extracted is equal to the count of data in ssicrmdb.
- re-create the query for denomalization and computation of some fields