If you want to create the star schema yourself, follow the steps below. For the detailed instructions consult the Pentaho wiki.
-
Start Pentaho Data Integration using
spoon.bat
from$PENTAHO_HOME$/design-tools/data-integration
. -
Create new transformation.
-
Create new database connection for the transformation: