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 target connection. You can select an
existing connection, create a new connection, or define
parameter values for the target connection property. If
you want to overwrite the target connection properties at
runtime, select the Allow parameter to be overridden
at run time option. |
Target Type | Type of the Microsoft SQL Server target object
available. You can choose from the following source types:
|
Parameter | A parameter file where you define values that you want to update
without having to edit the task. Select an existing parameter for
the target object or click New Parameter
to define a new parameter for the target object.The
Parameter property appears only if
you select parameter as the target type.If you want to
overwrite the target object at runtime, select the
Allow parameter to be overridden at run
time option.When the task runs, the
Secure Agent uses the parameters from the file that you specify
in the advanced session properties. |
Object | Path of the Microsoft SQL Server target object based on target type
selected. Specify the target object that you
want to create at run time. You can also select an existing
object from the list. |
Operation | Select the target operation. You can perform the
following operations on a Microsoft SQL Server target:
|
Data Driven Condition | Enables you to define expressions that flag rows
for an insert, update, or delete operation. Appears only when the
operation type is Data Driven .To configure a
data driven expression in a mapping, you need to specify the
expression that uses the IIF function. |
Update Columns | Click Add to select the
columns that you want to use as a logical primary key for performing
update, upsert, delete, and data driven operations on the target.
This field is not required if the target table already has a primary
key. |
Truncate target | When you enable the Truncate Target option,
the Secure Agent truncates the table before running the task.
Default is not selected. |
Enable target bulk load | Uses Microsoft SQL Server bulk API to insert data
in bulk mode. When you create a mapping
task, you can use the Microsoft SQL Server bulk API to perform
insert operation. |
Forward Rejected Rows | Determines whether the transformation passes
rejected rows to the next transformation or drops rejected
rows. If you select the option, the Secure Agent flags the
rows for reject and writes them to the reject file. If you do
not select the option, the Secure Agent drops the rejected rows
and writes them to the session log file. The Secure Agent does
not write the rejected rows to the reject file. |
Pre SQL | Pre-SQL command to run against the target database
before writing data to the target. |
Post SQL | Post-SQL command to run against the target
database after writing data to the target. |
Update Override | An update SQL statement that updates the data in a
Microsoft SQL Server target table. The update SQL statement you
specify overrides the default update statements that the Secure
Agent generates to update the target based on key columns. You can
define an update override statement to update target tables based on
both key or non-key columns. In the override statement, you must
enclose all reserved words in quotation marks. |
Additional Properties | You can override the properties set at the connection by providing
key-value pairs. The connector defines the keys you can use. You can
provide multiple values for a key, separated by
semicolons. To
specify the environment SQL value, provide the key-value pair in
the following format: INFA_ENV_SQL=<value1;
value2> Example: INFA_ENV_SQL=SET
QUOTED_IDENTIFIER ON; You run SQL queries
within the same session in a Target transformation when you set
the environment SQL value. |
Reject file directory | The directory that stores the rejected
files. |
Reject filename | Name of the rejected file that is stored in the
reject file directory. |
Schema Name | Overrides the schema name of the target
object. |
