Oops :-)

[thomaskejser]

Hi Dm_unseen

Indeed, I did confuse you with Dan, sorry. Yes, I will be at SQLBits, but unfortunately I will not have time for the pre-con there.

I will be doing a presentation about scalability though, hope to see you there.

[ssofiane]

Hi,

From previous posts I noticed that performance may be an issue and if it's the case than for me Dimensional Modeling is the best way to answer business questions efficiently, regardless the speed comparison related to physical infrastructures.

The bigger issue is auditing and you can see the Kimball Tip26 about adding an audit table in the EDW:
http://www.kimballgroup.com/html/designtipsPDF/DesignTips2001/KimballDT26AddingAnAudit.pdf

From the above Dimensional Modeling is a solution for best efficiency answering enterprise wide needs, whereas Data Vault would be the best answer for business willing to have a fast-track solution (COULD BE COST EFFECTIVE) for a project scope rather than a program scope.

Sofiane