Saved Queries
A saved query is a source object that you can create from one or more database tables. You can use a saved query as the source object in a Data Synchronization task.
Create a saved query when you want to use a database source that you cannot configure using the single- or multiple-object source options. For example, you might create a saved query to include source filters, or to perform a complicated join of multiple tables.
To use a saved query in a Data Synchronization task, first create the saved query component.To use a saved query in a Data Synchronization task, first create the saved query. Then when you configure the Data Synchronization task, select the saved query as the source object. You can add one saved query to a Data Synchronization task.
To use saved queries, your organization must have the appropriate license. For more information, contact Informatica Global Customer Support.