I'm new in the forum and in the world of Pentaho.
I should do a project for an exam and I'm working by himself as the professor did lessons.
Should I create a data warehouse.
I created 4 database in MySQL with PHPMYADMIN and created a local server with MAMP.
Now should I create transformations.
To create tasformazioni with data from different databases, you should always create your connections to the repository (then Tools -> Repositories -> Connect to repository -> "+")?
In addition to the reconciling, I will have to create a new database instance for riconciliari tables "State" of the various DB I have to create a new database in which there is a single table "State" to go to put the results obtained from the processing?