Viewing 15 posts - 1 through 15 (of 25 total)
If you want to be pedantic...
SQL 2012 is out of mainstream support (so if...
March 7, 2018 at 3:27 am
March 7, 2018 at 1:54 am
OK. We have decided we do not need to store all parameters in a separate table. Some parameters are required.
In the below updated design, I have put parameters Fund,...
February 17, 2018 at 7:41 am
February 16, 2018 at 11:09 am
Unfortunately this has not yet been determined. We are looking to design and plan for all possible requirements.
The DW data is likely to be used in Excel macros...
February 16, 2018 at 10:49 am
Hi again.
Thanks for all the help previously. I now have an Investment tbl and an InvestmentRelation tbl added to the DW as shown in the first image below.
The InvestmentKey in...
December 20, 2017 at 8:49 am
In the future, could you follow basic netiquette that is been in place...
February 22, 2017 at 2:42 am
February 21, 2017 at 1:23 pm
Hi,
I am working on creating CRUD sprocs for this design.
For creating a Tag/Parent reference is the below sproc correct? I am not sure whether I should...
February 21, 2017 at 10:43 am
February 20, 2017 at 10:27 am
February 20, 2017 at 9:41 am
February 20, 2017 at 9:26 am
February 17, 2017 at 6:47 am
Hi,
The Data Warehouse is working successfully. Thanks for all the help!
One new request now is to build a report to reconcile the data from both sources. So basically I need...
December 29, 2016 at 4:46 am
MMartin1 (12/14/2016)
a) Creating a surrogate key should be a normal routine
b) If there is no business ID (primary key usually) in your source data , try communicating to...
December 19, 2016 at 10:29 am
Viewing 15 posts - 1 through 15 (of 25 total)