This is Part 1 of BIML Series. Since we are going to generate automated Stage and DataVault packages from scratch, there are few prerequisites. This blog is to fill the gaps before we get started with BIML Script.
Assuming the reader has prior knowledge of XML, basic programming,basic BIML and SQL. If not, please refer to following links.
Knowledge Centre:
https://docs.varigence.com/bimlexpress/index.html
http://bimlscript.com/walkthrough/Details/3110
The following versions were used during demonstration.
Visual Studio 2017 (SSDT), BIML Express 2017 and SQL Server 2017.
During the course of this series i will be using the following databases. All the databases are created for demonstration purpose.
Following is the purpose of each database.
ETL_DataVault will host HUB, LINKS and SAT objects.
ETL_Log data will serve the purpose of logging.
ETL_Stage serves as reflection of source database with additional DWH (Data Warehouse columns).
Meta database will have Source to Target mapping.
Now, we have everything to get our hands dirty with BIML.
In the next blog, we will create our first stage package using BIML.
Tweak 