Follow

How to use the query table tool

Normal TX DWA staging tables are populated with a simple SELECT <Fields> FROM <Source Table> query. While some conditions may be added to this query with incremental and data selection rules, more advanced queries can be done by creating a query table.  This feature allows you to create a new table populated with custom query against the source database.

Note that complex queries may increase the processing load in the source database during the transfer phase of execution.

Creating a query table

Right-click on the Data Source you wish to query and select Data source Settings

KB_1.png

Go to the Query tables pane and press Add

KB_2.png

The new table will be called QueryTable by default

KB_3.png

Give the table a name and enter a schema. The schema is not for the data source table, but the table schema for the staging table. The source schema must be specified in the query. The {0} feature splits it up in the various accounts.

KB_4.png

Press Apply and synchronize with the data source.

Your new table will appear in the Data Selection window of your data source. 

KB__.PNG

If you preview the data you will be able to see it split up in the various Accounts, due to the use of {0} in the select statement.

KB_6.PNG

 

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.