Please forgive me if this is wordy. I am working on a future strategy for our BI environments…
3 hours, 28 minutes ago
I have data in a file that I get on a daily basis and use SSIS to import it in to my databa…
1 month, 3 weeks ago
By: Jeff Moden
What are the best practices to follow when merging duplicate date dimensions?
2 months, 1 week ago
By: Chris Harshman
I have a use case (below) for which I am considering multiple options. I am hoping to …
3 months, 2 weeks ago
I am looking at automating a repetitive task (using SSIS) and would be interested to know if anybod…
5 months ago
Hello, I have a standard type 2 SCD that is performing well however the business have asked for add…
sorry I am fairly new to data warehousing, though I have some little experience and concepts…
5 months, 2 weeks ago
Up to this point I've only worked with relational databases. I'm trying to teach myself data w…
5 months, 4 weeks ago
Please indulge me for asking a rather vague, 10,000 foot type question. I hope to get some feedback…
6 months, 1 week ago
I am using a sequence as the durable key (DK) of a dim table. It gets its value from a sequence f…
6 months, 4 weeks ago
I want to use a Type 2 SCD SSIS transform on a dimension table that does not have a durable key. …
I was hoping somebody would be able to offer advice in relation to tracking history in a fact t…
7 months ago
I need advice. I am in the designing phase of building a DW.
Question 1:- My source has (C…
A friend of mine asked me an interesting question... Given a flight path (a linestring of sorts), c…
7 months, 1 week ago
Hi, I am wondering what peoples thoughts are on "Pre Staging" data in the ETL Process.
I have only …
By: MVDBA (Mike Vessey)
Viewing 15 topics - 1 through 15 (of 499 total)
You must be logged in to create new topics.