- 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.
- modiry the ktr for tranform for breaking the denormalization of data per brand