Topics
Started by
Posts
Last post
Is there a best practice for what source data to use during development. I could use data from the …
3 replies
This is actually a follow up to an earlier question about a Type 2 SCD. Anyway, we have decided on …
6 replies
I have to modify the design of a data mart I "inherited." Currently the big picture is this: ETL S…
5 replies
hi my fact table consist of 4 dimensions. I have a composite primary key on all the 4 dimensions. …
2 replies
I am monitoring the performance of several buildings across the country. Each building contains a d…
1 replies
Should the surrogate key, for instance customerKey for dimension customer, be created in the stage …
5 replies
Hi Guys, Been a while since I posted but I think I could really do with the thoughts of some more p…
2 replies
When you load the Staging table for an Incremental Load is it not common practice to do a compariso…
16 replies
I would appreciate the recommendation of experienced people in the below scenario. Thanks in advanc…
1 replies
Perhaps a classic example that i have missed, but i am looking for a solution to design this. This …
1 replies
I am doing an archiving process in the following manner: 1) Execute SP's on ProdServer.ProdDb to ex…
1 replies
Here is a simple case study for which we are looking to design a Recon Report or leverage existing …
7 replies
I am creating a data mart. We want to use it to analyze help desk tickets. The data will be pulle…
9 replies
This question is about business intelligence with sql server 2008 R2. If you have a person named Ji…
5 replies
I have a data warehouse for a retail client that has boutiques. They want to be able to compare th…
1 replies
Viewing 15 topics - 331 through 345 (of 541 total)
You must be logged in to create new topics.