A common task when implementing a data warehouse is to build the same sort of table over and over again. When using the Data Vault method to build the storage data model this occurs when building Hubs, Links and Satellites. These often have the same implementation, with only minor differences. The ETL-workflows to load these tables are quite similar as well.
In virtually every ETL-tool it is possible to export workflows to text, for instance XML files. These flows can then serve as template for other flows of the same type. Of course, this also works with SQL tables, view definitions, etc.
The Templator provides a quick and easy way to generate similar texts by using a global search-and-replace over a template, for many different variables at the same time.
It works like this: first, fill out all the fields below. Then press the button and a download will start. In the download you will see the template you entered repeated for each line of replacements, but with all variables (for instance P_TABLENAME) replaced by the values in the data lines.
The download contains all the templates with their replacements in one file. You may need to edit the file before using
Version notes and an example can be found at the bottom of the page.
The following settings provide an example of how this tool works:
- Parameters:
P_TABLENAME;P_VAL1;P_VAL2; - Template:
INSERT INTO P_TABLENAME VALUES ( P_VAL1, P_VAL2 ); - Parameter values:
TEST;1;2;
TEST2;3;4;
Remarks for version 1.0:
- Too many templates and parametervalues might cause the server to cut off the processing and results in an empty download.
- A space at the end of the parameters will result in a file where all spaces have been removed (replaced by (empty)).