For loop can be used to setup a loop to selecting all CSV’s in particular location based on a pattern like C:App*.csv for all files starting with App in their name in C Drive root Folder. Thi
Surrogate keys and lookup Transformation in Developing Data Warehouse: With conformed Dimensions approach, the Sk’s are created in when Dimensions are created by using Identity prope
How is the Audit table helpful in DataWarehouse Development Cycle? The answer looks obvious which is debugging the package but what kind of information is normally loaded into a Audit Table and how i
Designing Audit table for Data Warehouse. Step1: Create a table with no refential integrity or identity first using script below.(Alter as needed)
![1 2 Next »](https://sql-developers.co.uk/wp-content/uplo
</p>
</div> </div>
</div>
</article>
<article id="post-575" class="post-575 post type-post status-publish format-standard has-post-thumbnail hentry category-business-intelligence category-data-warehouse category-sql-development category-sql-server-development category-sql-server-integration-services layout-grid col-md-12 col-sm-12 col-12">
<div class="article-content-col">
<div class="content">
<div class="nv-post-thumbnail-wrap"><a href="https://sql-developers.co.uk/business-intelligence/tips-developing-data-warehouse-1.html" rel="bookmark" title="Tips for Developing a Data Warehouse 1"><img width="228" height="360" src="https://sql-developers.co.uk/wp-content/uploads/2020/02/IMG-20200226-WA0022-e1582805861138.jpg" class=" default-featured-img" alt="" loading="lazy" srcset="https://sql-developers.co.uk/wp-content/uploads/2020/02/IMG-20200226-WA0022-e1582805861138.jpg 228w, https://sql-developers.co.uk/wp-content/uploads/2020/02/IMG-20200226-WA0022-e1582805861138-190x300.jpg 190w" sizes="(max-width: 228px) 100vw, 228px" /></a></div><h2 class="blog-entry-title entry-title"><a href="https://sql-developers.co.uk/business-intelligence/tips-developing-data-warehouse-1.html" rel="bookmark">Tips for Developing a Data Warehouse 1</a></h2><ul class="nv-meta-list"><li class="meta author vcard"><span class="author-name fn">by <a href="https://sql-developers.co.uk/author/admin_vb" title="Posts by Admin_vb" rel="author">Admin_vb</a></span></li><li class="meta date posted-on"><time class="entry-date published" datetime="2012-04-16T16:58:24+01:00" content="2012-04-16">April 16, 2012</time></li></ul><div class="excerpt-wrap entry-summary"><p>1. Think of the Business requirements first. 2. Get the list of source destinations 3. Setup a Staging Database to separate out the “Extract” out of ETL. 4. Always use master and child packages for ma</p>
</div> </div>
</div>
</article>
</div><ul class=){kind=link}