Toad World® Forums

Help with generating a star schema


#1

So this is my first week using Toad and as a data architect intern so be easy on me if I am wrong about anything.

I currently have a staging model with data mart fact and dimension tables. These are raw tables so no keys have been designated yet. Is there a way that Toad can generate a star schema by using certain tables I have selected and connecting each fact table with the dimension tables that share the same attributes, even if there are no primary or foreign keys designated?

Thanks in advance!