Adatis BI Blogs

What's New

  • DQS Reference Data Services with SSIS

    Rather than just using the the local domain values in its internal knowledge base, Data Quality Services (DQS) can instead clean data by using external reference data. This is a feature called Reference Data Services and in this blog post I’m going to show an example of cleaning SSIS data by connecting to the Azure Data Market. Azure Data Market After...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 07-24-2014
  • From Nothing to Source Control

    Source Control, often called Revision Control or Version Control, is a process of maintaining projects. It is essential for any software project, collaborative or otherwise. Below is a non-exhaustive list of benefits of Version Control: Version Control and Tracking Provides locking and serialized changes to any file Structure Everyone operates in the...
    Posted to Dan Evans' Blog (Weblog) by Dan Evans on 07-23-2014
  • Optimising SSIS Lookups with HASHBYTES()

    I was recently working on a load for a Dimension table which worked like the below. The package follows a fairly standard routine. Data for the Dimension is transformed into the required format using SSIS, following this it is inserted into the target table. On the way an initial check is made to determine if the record is new ‘LKU – Check Exists’ and...
    Posted to Jonathon Eve-O'Connor's Blog (Weblog) by JEOC on 07-14-2014
  • Master Data Services Regular Expression Business Rules

    As those of you who use MDS will know, the Code attribute within a Master Data Services entity is mandatory, as its used to uniquely identify the members within the entity. Not only is it mandatory, but unfortunately you cannot change its underlying SQL Server data type – it always gets created as an nvarchar. This is useful in some cases, but what...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 07-01-2014