Copy data between DWs/DSs

Link to this posting

Postby Ursego » 04 Mar 2013, 15:45

Data can be copied from one DW/DS to another in a very simple way:

Code: Select all
<target DW or DS> = <source DW or DS>

But there is a potential issue in that approach which forces us to dilute our business logic with some boring technical code: if the source has no rows, then a runtime error occurs when you grab <source DW or DS> That problem is solved in a small autoinstantiated NVO n_copy_data which is downloadable here. It has four overloaded functions uf_from_to(<source DW or DS>, <target DW or DS>). They make sure that there is at least one row to copy.

If you want to add these function to another NVO (or to your ancestor DW/DS) then change their name to uf_copy_data_from_to (the name uf_from_to is understandable only in the context of n_copy_data, like lnv_copy_data.uf_from_to...).
User avatar
Site Admin
Posts: 140
Joined: 19 Feb 2013, 20:33

IF you want to ((lose weight) OR (have unbelievable (brain function AND mental clarity))) THEN click:

Traffic Counter

free counters

eXTReMe Tracker