How do you identify existing rows of data in the target table using lookup transformation?

                                                                                                                                                                      

Scenario:

How do you identify existing rows of data in the target table using lookup transformation?

Solution:

There are two ways to lookup the target table to verify a row exists or not:

1. Use connect dynamic cache lookup and then check the values of NewLookuprow Output port to decide whether the incoming record already exists in the table / cache or not.

2. Use Unconnected lookup and call it from an expression transformation and check the Lookup condition port value (Null/ Not Null) to decide whether the incoming record already exists in the table or not.