Query tables in TimeXtender Classic's Business Unit enable customized SQL queries against source databases, creating staging tables with transformed or filtered data. Unlike standard staging tables using basic SELECT statements, query tables handle complex logic like joins, aggregates, and conditional splits during extraction.

Key Benefits

• Enables source-side transformations before staging.
• Supports advanced SQL syntax for tailored data shaping.

Use Case: Source Side Joins to Filter Data Extraction: The ideal way to select rows for extraction might only exist when joining two tables. e.g. Filtering "SalesOrderDetail" on OrderDate, where OrderDate only existing in the "SalesOrderHeader" Table.

Implementation Steps

1. Right-click target Data Source → Data Source Settings.
2. Navigate to Query Tables → Add.
3. Configure:

• • Name: Define table identifier.
  • Schema: Set staging schema (not source schema).
  • SQL Query: Write custom logic (use {0} for splits).
    
    
    
    

1. Apply → Synchronize.
2. Validate via Preview Data to confirm account splits/transformations.

Query tables optimize ETL pipelines by shifting transformations to the extraction phase, reducing downstream processing.

Caution: complex queries may increase source database load during execution.