How to separate a concatenated fact table and build link table ?
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 ?
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 ?