Approach to testing data warehouse on the basis of MS SQL Server

At first sight the warehouse doesn't seem to be quite a unique system. It is one of the ways to store database. Like the storeroom of a hamster who lays food for the winter. Nevertheless it's own features, in particular, in testing. It has set of integration of components & the semantics of data. I would like to share the approach to testing of storage of data on the basis of MS SQL Server which was accepted in our team. I will lay out the examples of automation of the main logic of process of testing by means of tSQLt framework. I will tell about the sequence and the essence of the steps, and also problems which were faced while working on the project.