Data Integration-Free and PayGo
- Data Integration-Free and PayGo
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
Property
| Description
|
|---|---|
Connection
| Name of the source connection.
|
Source Type
| Source type.
|
Object
| Source object for a single source.
|
Add Source Object
| Primary source object for multiple sources.
|
Add Related Objects
| For multiple sources. Displays objects related to the selected source object.
Select an object with an existing relationship or click
Custom Relationship
to create a custom relationship with another object.
|
Filter
| Adds conditions to filter records. Configure a simple or an advanced filter.
|
Sort
| Adds conditions to sort records.
|
Select Distinct Rows Only
| Reads unique rows from the source. Adds SELECT DISTINCT to the SQL query.
|
Define Query
| For a custom query. Displays the
Edit Custom Query dialog box. Enter a valid custom query and click
OK .
|
Tracing Level
| Detail level of error and status messages that
Data Integration writes in the session log. You can choose terse, normal, verbose initialization, or verbose data. Default is normal.
|
Pre SQL
| SQL command to run against the source before reading data from the source.
You can enter a command of up to 5000 characters.
|
Post SQL
| SQL command to run against the source after writing data to the target.
You can enter a command of up to 5000 characters.
|
SQL Query
| SQL query to override the default query that
Data Integration uses to read data from the source. You can enter an SQL statement supported by the source database.
|
Output is deterministic
| Relational source or transformation output that does not change between mapping runs when the input data is consistent between runs.
When you configure this property, the Secure Agent does not stage source data for recovery if transformations in the pipeline always produce repeatable data.
|
Output is repeatable
| Relational source or transformation output that is in the same order between session runs when the order of the input data is consistent.
When output is deterministic and output is repeatable, the Secure Agent does not stage source data for recovery.
|
