The Integration Service flags the rows in the Lookup transformation based on the inserts and updates it performs on the dynamic cache. These rows pass through an Expression transformation to a Router transformation that filters and passes on the inserted and updated rows to an Update Strategy transformation. The Update Strategy transformation flags the rows based on the value of the NewLookupRow port.
The output values of the lookup/output and
input/output
output
ports depend on whether you choose to output old or new values when the Integration Service updates a row. However, the output values of the NewLookupRow port and any lookup/output port that uses the sequence ID is the same for new and updated rows.
When you choose to output new values, the lookup/output ports output the following values:
NewLookupRow
PK_PRIMARYKEY
CUST_ID
CUST_NAME
ADDRESS
2
100001
80001
Marion Atkins
100 Main St.
2
100002
80002
Laura Gomez
510 Broadway Ave.
1
100004
99001
Jon Freeman
555 6th Ave.
When you choose to output old values, the lookup/output ports output the following values:
NewLookupRow
PK_PRIMARYKEY
CUST_ID
CUST_NAME
ADDRESS
2
100001
80001
Marion James
100 Main St.
2
100002
80002
Laura Jones
510 Broadway Ave.
1
100004
99001
Jon Freeman
555 6th Ave.
When the Integration Service updates rows in the lookup cache it uses the primary key (PK_PRIMARYKEY) values for rows in the cache and the target table.
The Integration Service uses the sequence ID to generate a primary key for the customer that it does not find in the cache. The Integration Service inserts the primary key value into the lookup cache and it returns the value to the lookup/output port.
The Integration Service output values from the
input/output
output
ports that match the input values.
If the input value is NULL and you select the Ignore Null property for the associated input port, the input value does not equal the lookup value or the value out of the
input/output
output
port. When you select the Ignore Null property, the lookup cache and the target table might become unsynchronized if you pass null values to the target. You must verify that you do not pass null values to the target.
ASK INFAPreview
