Hi, I'm Ask INFA!
What would you like to know?

ASK INFAPreview

Please to access Bolo.

Search

PowerExchange for Siebel User Guide for PowerCenter

PowerExchange for Siebel User Guide for PowerCenter

10.5.4
- 10.5.5
- 10.2

Back Next

Configuring Sessions for a Siebel EIM Read Transformation

Configuring Sessions for a Siebel EIM Read Transformation

The following table describes the session properties that you can configure for a Siebel EIM Read transformation:

Session Property	Description
Rows to Read	Select one of the following values to filter the rows to read from the Siebel EIM table: Successful. Reads all rows that have the IMPORTED, EXPORTED, MERGED, or DELETED status in the IF_ROW_STAT column. Erroneous. Reads all rows that do not have the EXPORTED, IMPORTED, MERGED, DELETED, FOR_IMPORT, FOR_MERGE, or FOR_DELETE status in the IF_ROW_STAT column. All. Reads all the rows. The Successful and Erroneous options are applicable when the PowerCenter Integration Service extracts data after the load operation is executed. Default is blank. When you do not specify a value, the PowerCenter Integration Service uses the value set for the Rows to Read transformation property.
Error Count Limit	Enter a limit for the error count. Set to '0' to disable the limit. Valid values include 0 to 2^31-1. Default is 0.
Filter	Enter the filter condition to filter the rows read from a Siebel EIM table. You can configure a filter for multiple Siebel EIM tables. Use the following syntax: [<Siebel EIM table name>:<SQL WHERE clause>] For example, to apply the filters, enter the following filter values: [EIM_AC_RSRC:ACR_NAME like 'Acr%'][EIM_ACCNT_CUT:PARTY_UID='1-D1916' and AC_NAME like 'Acc%']
Delete Rows	After the PowerCenter Integration Service extracts data from the Siebel EIM table, you can delete the rows from the Siebel EIM table. Select one of the following values to delete rows from the Siebel EIM table: Successful. Deletes all rows that have the IMPORTED, EXPORTED, MERGED, or DELETED status in the IF_ROW_STAT column. All. Deletes all the rows. None. Does not delete any row. Default is None.

Siebel Sessions

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.