1. Make a union of Id from Table b and Table c in your extraction query.
2. Lookup Table a and the above extraction and mention lookup condition not matched to failure.
So in the look up stage in the constraints under the condition we can write the SQL right? So could you give an example considering the above case? I doubt if I can use the normal SQL
Hi,
I am sorry...what i mean is write a User Defined SQL in your Lookup reference stage and compare both the records in the next stage that is transformer.
oh! I know that I can write an user defined sql in the Reference stage and compare in the look-up. By what she said I thought we can write sql in the condition tab of lookup. My reference stage is not oracle its an SFDC stage and I am not good at writing user-defined SQL in the SFDC so that is the reason for asking if there is any way in lookup stage to compare two links.
1. After extraction of b add a transformer and default a colunmn say COL1 with some default value and declared as nullable yes
2. Then first look up with a an b with a as stream and set both as continue.
3.Look up the record set with with c.In the look up condition gives COL1 is null.And set the options as continue and Failed,