Developer Tool Guide

10.5.1
- 10.5.2
- 10.5

Back Next

Creating a Custom Query

Create a custom query to issue a special SELECT statement for reading data from the sources. The custom query overrides the default query that the Data Integration Service issues to read source data.

Open the customized data object or the relational data object instance.

Select the

Read

view.

Select the Output transformation.

Select the

Query

properties.

Select the advanced query.

Select

Use custom query

The Data Integration Service displays the query it issues to read source data.

Change the query or replace it with a custom query.

If you want to push the custom query to the relational data source, select

Push custom query to database

The Data Integration Service does not the push custom query to the database by default. Choose to push the custom query if the query forms a valid subquery for the database.

Save the data object.

Custom Queries

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal