Thanks for your reply

i guess in a business rules outlook then you could say

If Active=1 (forget about date) then set all the ID's that are linked by the linkID...

Im a bit confused if

"I can come up with a number of ways to accomplish based on the sample data" IS true then how can also be "Unfortunately I...

Well not sure if we had Replication here before. But since ive been here and been on 2012 we have always been Using always on (or tyring too) i think...

thanks Mike

what are the common options people use. we dont really want to re-architect things..

Sorry i thought i had listed the process clearly.

Im trying to build a Product dimension that has both type 1 and type 2 scd. Most product tables i have work...

Thanks Koen

How do you know what and when something should be in the dim tables or fact, this is what im find hard as just starting in DW, just...

So the designers prices and surcharges would go in the product dimension as they are fixed im sure when the product is created. But would pull the the retailers prices...

yes, ive been working with 2012 and now 2014 SSIS and impressed with the speed ive seen

Thanks for the replays

and the one DW with schema separated tables seems to be coming up lots.

If this is employed the DW will reside in one location say...

gbritton1 (4/21/2014)

---

Kinda hard to answer without knowing lots more.

e.g.

1. will most BI reporting be country-specific? (argues for separation)

2. what are the expected table sizes? (if small-ish, no value in...

This is very interesting 🙂

Im doing some reading now on this now, i hope you don't mind answering any other questions this produces. Bu wanted to thank you anyway for...

Informative response thanks 🙂

When you say "column-store and in-memory tables" what exactly do you mean, im somewhat new to DW.

Hard to be specific as our systems are changing state just now but I would definitely say on the smaller side 10-20gb

i had a look, im not sure if this will give me the ability to dybamicaly build the column groupings. or am i missing somthing - possible

"The "5" in both forumlas could be any constant but either 1 or 5 seem to be the easiest to understand"

so the 5 is an arbitrary value that is commonly...