This project is an implementation of Data Warehouse creation which is build by using Talend on dataset based on Customer along with sales Data.
Understand the workflow of Talend data warehousing.
There are two data Sources from single type, Customer Information Transaction
Talend collects data from two different data sources which are in csv form. For importing I have used single Metadata for db connection, and it connects two different sources initially.
- Joinning data tables into one.
- Filter Data as per requirements.
- Generate output.
All by following one execution click.
Output was based on requirements, and export it to one csv file along with one MySQL database (Two types of databases). However, it can be used to send to some other type of sdatabases for further investigation and Visualization. The Main essence is that we don’t need to repeat the same work again and again rather we can simply run the whole framework and get the output irrespective of the unknown raw data generates everyday.