When creating a database and an ETL process to either load or extract from it, you can help yourself quite a bit by creating a metadata repository. The benefit of this metadata is that you can use it to create data-driven ETL and other processes: instead of creating numerous lines of code for each particular object, you can create a dynamic process which uses metadata to perform the appropriate ETL for all your objects.
© Exsilio Solutions 2013
All rights reserved.
What’s on our mind?
Exsilio Solutions is proud to introduce our new blog! Not only is this forum completely integrated with all our social networks, but it is also 100% responsive. Now, you can take Exsilio with you on your phone, tablet, and desktop - redefine what you thought possible!
Parallel Optimization in SSIS 2012
Being able to run multiple stored procedures in parallel can provide a major performance boost when loading a data warehouse. In this post, I’ll describe a process which will take full advantage of server resources by running multiple procedures in parallel.