Adding data to a existent table - how to (in a clean way)

[chriys1337]

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

[Anonymous]

Hey, chriys1337

           i use like you kkk