✍ Kashif M
Trends

Sunday, 7 July 2013


UPDATE STRATEGY EXPRESSION IN INFORMATICA


By on July 07, 2013


First, declare a Look Up condition in Look Up Transformation.

For example,

EMPID_IN (column coming from source)  = EMPID (column in target table)

Second, drag and drop these two columns into UPDATE Strategy Transformation.


Check the Value coming from source (EMPID_IN) with the column in the target table (EMPID). If both are equal this means that the record already exists in the target. So we need to update the record (DD_UPDATE). Else will insert the record coming from source into the target (DD_INSERT). See below for UPDATE Strategy expression.

IIF ((EMPID_IN = EMPID), DD_UPDATE, DD_INSERT)

NOTE: Always the Update Strategy expression should be based on Primary keys in the target table.

Kashif
mkashu: UPDATE STRATEGY EXPRESSION IN INFORMATICA
Review : Kashif | Kashif
Update: July 07, 2013 | Rating: 4.5

Comment for "UPDATE STRATEGY EXPRESSION IN INFORMATICA"

0 comments

Post a Comment

Blog Archive