Load ST_Stage day 2

The following script will load a source table with day 2 example data. It will be used later to load that data into the example anchor model.

 

With the following script data is loaded in a step-by-step manner into the data model. It explains what happens at every step and how loading should be done in general.

 

This is an example of a Merge statement, which can be used to achieve the same functionality as in the script above. Once you understand the step-by-step example you can move on to the more compact merge syntax.

Leave a Reply

Your email address will not be published. Required fields are marked *