The design-considerations tag has no wiki summary.
3
votes
1answer
132 views
SSIS Design consideration with object variables
I have an SSIS package for SQL Server 2008 R2. In the package I am required to work with an Access database (one to many) and iterate through it running validation checks with the data. The validation ...
3
votes
1answer
59 views
Should I snowflake or duplicate it across my facts?
I'm building up a data warehouse to be used by SSAS to create cubes on, and I'm debating between two possible schemas.
In my warehouse, I've got two different fact tables that tracking daily changes ...
2
votes
0answers
46 views
Two different ON DELETE paths, how do I need to change the schema?
For a project in school I'm designing a website that sells items via auctions. Think eBay, but on the complexity scale of school project. We went through the process of making an ER Diagram and ...
3
votes
1answer
404 views
SSIS package with BULK data load
I analyzed a C# program over the weekend for a customer that basically does the following:
Truncate Table
Fetch Data (source on these is either remote database or local database where job runs)
...
