Query Propagation

Query propagation is a technique most useful when operating a pull model of transforming data when the source data is RDBMS. Transforms are defined first to transform from the source data to the target data.

Once this is done, query propagation allows data to be retrieved by a query expressed in the target data format. Using the transforms already defined, the equivalent query in a source data format is generated and the data retrieved and transformed to the target model.

Significantly, TM deduces only the data that should be selected, and implements an appropriate SQL command, thus providing significant performance improvements over systems that read all data to interpret the data that is required.

For more detailed information on Query Propagation on TM please read our Query Propagation Overview document.