Here are 2 tables that are concatenated. Requirement is to remove the concatenated fields into another link table and create generic keys.
How do you separate a concatenated table and link with generic keys ?
Details Plan
OrderID Company
Item Number Brand
Line Type Market
Here is a script to concatenate . The issue is the concatenated 'Details' table only shows up in data model with this concatenate statement. If I make any changes to this script the 'Details' table does not show at all. What is causing this ?
CONCATENATE (Details) load
Company,
Brand,
Market
resident Plan;
drop table Plan;