• Home
  • Docsumentation
  • Automation
  • Releases
  • Issues tracking
  • View on GitHub

NBi Logo

  • Home
  • Docsumentation
  • Automation
  • Releases
  • Issues tracking
  • View on GitHub

Concept of metadata


Metadata are additional information about the tests. They represent a set of facultative xml elements used to facilitate the edition or the execution of the tests but they don’t impact the test itself. Withh the help of the metadata you’ll be able to define following information

  • description
  • ignore
  • not-implemented
  • edition (author and updates)
  • categories
  • traits
  • group of tests
Back
Next

Getting started

  • Welcome
  • Bootstrapper for Visual Studio
  • NBi's setup
  • Test environment's setup
  • Test-suite file
  • NUnit project file
  • Configuration file
  • Run test-suite with NUnit
  • Alternative setups

Equivalence of result-sets

  • Equivalence of two result-sets
  • Configuration for comparison
  • Special and generic values
  • Tolerances and roundings
  • Intervals of values
  • Single row
  • Superset of/subset of

connection strings

  • Connection strings in config files
  • Database providers
  • Power BI Desktop
  • Apply roles to a query

Lookups' testing

  • Lookup exists
  • Reverse-lookup exists
  • Lookup matches

Additional tests for result-sets

  • All/no/some/single rows validate a predicate
  • Expressions and predicates
  • Rows' count for a result-set
  • Rows' count (advanced)
  • Rows' uniqueness
  • Cell's format in a result-set

Primitives

  • Scalar
  • Sequence
  • Result-set
  • Transform a scalar
  • Native transformations
  • Alterations

Query's execution

  • Validate syntax
  • Performance

Define a query

  • Define a timeout
  • Query's parameters
  • Query's template-variables
  • Get a query from an assembly
  • Get a query from a report
  • Get a query from a shared datasets

Etl (SSIS)

  • Define an etl
  • Etl's parameters and variables
  • Successful etl
  • Etl's performance
  • Etl's side effects

Model (DB/SSAS)

  • Testing the objects of the model
  • Existence of an object
  • Collection of objects
  • Relation between objects
  • Data types

Members (SSAS)

  • Members
  • Members' count
  • Members' ordering
  • Members' existence
  • Members' source
  • Members' patterns

Setup and Cleanup

  • Setup and cleanup
  • Data engineering
  • Files' manipulations
  • Processes and services
  • Conditions for execution
  • Custom commands and conditions

Extensions

  • Connect to other databases
  • Install extensions
  • Flat file extensions

Configuration and settings

  • Defaults and references
  • Settings in external file
  • CSV profile
  • Failures' report
  • DTD processing
  • Traces for debugging

Variables

  • Define variables
  • Override variables
  • Instance variables

Metadata

  • Concept of metadata
  • Description
  • Ignore
  • Edition
  • Categories
  • Traits
  • Groups

Data quality engine

  • Setup for Data Quality Rules engine

Stay connected with us:

  • → Github
  • → Blog
  • → Twitter
  • → SlideShare

Logo

The contents of this website are © 2025 Cédric L. Charlier.

Hosted by GitHub, powered by Jekyll.