Query Chain
Query chain is powered with data preparation engine of DataTrust. The dataset to be validated may not always be ready to be validated state. Using Query Chain’s transformation capabilities you can apply the necessary transformations prior to configuring the validation processes.
Query Chain is also used for taking snapshot of the result into DataTrust’s datastore database. This function helps minimize the roundtrips to the source system thereby reducing the impact on source system. The post-transformed and prepared dataset can be used as datasource for subsequent validation processes.
Query Chain Designer Overview
Under query studio, go to left vertical menu bar > click on Query Builder > Click on “Query Chain” to create new query chain.
The designer page of Query Chain has the following features:
- A header design element to name the scenario and choose the level of hierarchy for saving the scenario.
- Data source design elements of all the data sources DataTrust supports.
- Transformation design elements like filter, aggregation, projection, Join, Union, Pivot, Un-pivot, De-dups, etc. One or more transformations can be added as a chain. Its highly recommended to use native transformation capabilities (in case of RDBMS, use SQL when the required transformation is supported).
- Extracted, transformed and cleansed data can be loaded into DataTrust database as a snapshot.
In the Query Chain Designer, the design palette is divided into 4 tabs.
Data Sources
Transformations
Output