I have 3 tables that all connect using a primary key of CustomerID. All of these tables also have a store_id field that is specific to that table. I then have a lookup table with store_id information which include information like store name and other store identifier information. When I try to load these I'm getting loop errors. What is the best way to load these?
Well, it ultimately depends on the data model and the specific questions that will be asked based on it. In any case, you could CONCATENATE the three tables and then link the attributes of the store to the resultant table.
