CODEWITHSUNDEEP
data-modelingmysql-workbenchpentaho
joris
joris

Reputation: 435

Modelisation of a star schema DB for a pentaho project (mysql workbench or schema workbench)?

I'm working on a BI project where I'm gonna use pentaho. I'm currently deisgning the DB. I know that in pentaho I need schema workbench to create my cubes and "universe" for the final users.

Can I first use mysql workbench to create and modelise my DW (star schema), and then use schema workbench for the cube creation?

Is it a bad solution that give me twice as work?

thks for your help

Upvotes: 1

Views: 861

Answers (1)

bagus prasojo
bagus prasojo

Reputation: 603

Can I first use mysql workbench to create and modelise my DW (star schema), and then use schema workbench for the cube creation?

Yes u can do that as long as the DB structure supports for star schema

Is it a bad solution that give me twice as work?

I think Yes

Upvotes: 1

Related Questions