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!