Hi all,
I am having a question regarding the style of data modelling.
There are multiple Resident Loads in my script, where I am just adding some information and therefore have to Reload the Table, rename it and drop the prior table, like shown in the script below
fact_table:
NoConcatenate Load *,
Trade & '_' & Matchcode as Trade_Matchcode,
Geo_From & '_' & Geo_To & '_' & Matchcode as Geo_From_To_Matchcode
Resident fact_table_tmp;
Drop Table fact_table_tmp;
Is there a cleaner version of touching tables and adding information?
Happy to get some ideas from you, thx a lot.
Chris
