Approach to testing data warehouse on the basis of MS SQL Server
  • Easy
  • 20 min

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.


Подход к тестированию хранилища данных на базе MS SQL Server from Vlad Orlikov on Vimeo.

Comments ({{Comments.length}} )
  • {{comment.AuthorFullName}}
    {{comment.AuthorInfo}}
    {{ comment.DateCreated | date: 'dd.MM.yyyy' }}