In this project, PentaHo was used to perform Data Modeling on the raw store data that looks like following:
A PentaHo job was created that would run all the transformations to create the dimension tables and the fact tables in order.This job can easily be scheduled to run on certain time with certain CSV file. However, the CSV file should have the data in the above shown format.
After the data modeling, our database schema looks as follows: