Gayathri84

 Profile Answers by Gayathri84 

• Jan 18th, 2007

 

You Can user a Joiner Transformation. Use the Target as a Source JOIN it with the Source '

Set the Joiner Condition and do the Required Tasks,

Thanks,
Gayathri

Gowtham

• Jan 26th, 2007

 

Suppose, the target table had no rows. Then who will u lookup the first time.

sidhu

• Jan 29th, 2007

 

Hey u can use a stored procedure to get the functionality of the look up.Pass the source rows as input to the SP,the SP will compare the input args to that of the target table , if value found can return some flag.Depending upon the outcome of the flag u can set ur condition.sidhu

Pradeep

• Mar 2nd, 2007

 

You could have a SQL override in the Source Qualifier with something like: select * from source_table where not exisits in target_table

jithendra

• Mar 6th, 2007

 

Hi,

you can have source left outer joined to target table using the key columns to verify if an incoming row already exists in the target.

e.g. consider A as source & B as target. And the key column is key_id in both tables, the join would be like

select A.*, b.key_id
from A, B
where
A.key_id = B.key_id(+)

now, in the mapping you can have logic to consider the row as new b.key_id is NULL and as existing if b.key_id is not NULL