Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to convert database in 3NF to Star schema

453437Oct 28 2005 — edited Oct 31 2005

Hi

Can anyone help me out to convert the database in 3NF to Star schema so that it can be used for Business Intelligence.

Our Application will be populating the database in normal 3NF form which may be difficult for the intelligence to generate queries from it. From the documents given, i saw that only star schema containing dimensions table and fact table is simpler to generate reports. Is there any tool that would convert the schema from 3NF to star schema?

Regards
S. Kokila

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 28 2005

Added on Oct 28 2005

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

4 comments

911 views