How to separate a concatenated fact table and build link table ?

[claudialet]

  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;