Sutha's SQL BI Blog - All Comments

re: Configuring MDS - MDS Configuration Manager

shrilata — Tue, 23 Feb 2010 17:17:05 GMT

Hi , I am new to MDM, My requriment is to make a client master which start from creting MDM hub. can any one tell me where to start.

In SQL DB when i created sample default MDS database it came with many tables does all that required to use. and any one has sample .Net app with business rules and entire flow. Thank you !!

re: Configuring MDS - MDS Configuration Manager

shrilata — Tue, 23 Feb 2010 17:13:10 GMT

Hi , when i launch the website it's throwing the error. some internet connection error. here i want to set my own app. could you continue as how to make ?

re: Late Arriving Facts & SSIS Contd

CozyRoc — Wed, 27 Jan 2010 20:19:10 GMT

There is solution based on the third-party commercial CozyRoc SSIS+ library. CozyRoc has implemented data flow destination script, which creates memory-efficient range dictionary object. The dictionary object can then be used in CozyRoc Lookup Plus component. For more information and demonstration how to use the script, check here:

www.cozyroc.com/.../range-dictionary-destination

select count(*) is slow on tables without index ?? Data Warehousing … | Business Intelligence Wisdom

Thu, 24 Dec 2009 04:41:33 GMT

Pingback from select count(*) is slow on tables without index ?? Data Warehousing … | Business Intelligence Wisdom

The trouble with data… » Blog Archive » SQL 2008 R2 Master Data Services

The trouble with data… » Blog Archive » SQL 2008 R2 Master Data Services — Fri, 11 Dec 2009 22:33:37 GMT

Pingback from The trouble with data… » Blog Archive » SQL 2008 R2 Master Data Services

re: MDS vs AS

tsutha — Tue, 08 Dec 2009 11:23:00 GMT

Jamie

Yes it would be great if we can and yes we can dream about it.

I think Chris Webb asked the same question to someone from MS @ SQLPass. I believe the answer was yes it is nice to have but we dont have any plans to put it in the immediate future. It might become available in Version 2 /3 .

Thanks

Sutha

re: MDS vs AS

jamiet — Mon, 07 Dec 2009 16:21:49 GMT

Wouldn't it be great if the dimensions we build in MDS were "linked" to those in AS so that any change to a dimension hierarchy in MDS automatically triggered a reprocessing of all the aggregations in AS. As it stands we're going to have to build something to do that ourselves and THAT will be a pain in the neck.

Ah we can dream...

It would also be nice if AS aggregated data for different versions of a dimension (where the versions are as defined in MDS).

There HAS to be closer integration beyween MDS and AS in the future. Has to be.

-Jamie

Pages tagged "facts"

Pages tagged "facts" — Sat, 06 Dec 2008 00:07:38 GMT

Pingback from Pages tagged "facts"

re: Late Arriving Facts & SSIS Contd

tsutha — Thu, 27 Nov 2008 14:02:04 GMT

Matt Masson has given a few alternative. He has written custom script which seems to outperform any other options. You can read all about on Matt's blog.

blogs.msdn.com/.../lookup-pattern-range-lookups.aspx

Thanks

Sutha