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