Hello, I have seven lookups in sequence, one after other if match found update some flag column as Y else update it as N and both the match and no match outputs has to flow to next lookup and continue on with same logic then finally write all those values to a table . First thing came to my mind when i thought about the solution for this is to union the lookup match n no match and send it to next look up but my manager told not to do it in that way as it may affect performance. How can I do this? I am not sure, are there any other component to do this?please advice

Can you give some example, data and ddl? But if you want to direct matching and nomatching data to the next task you have to use the union. It's the only component I know for that scenario. Maybe you can use a Script Component for that. I think for that you hav to join the lookups together with your data. But I haven't done in that manner yet.

Follow the below steps to achieve the same, In your first lookup go to General , you find "specify how to macth error rows with no matching entries"Select Ignore FailureDo other lookup stuffs and select any key column in Available Output Columns (what your business suggests )In the 2nd lookup also go to General , you find "specify how to macth error rows with no matching entries" and make it to Ignore FailurePut a derived column and check for ISNULL(key_column)?,"error_description","" this will be your reject reasonPut a condition split and filter derived columns for null, reject_reason==""Insert records to a your table where reject reason is null and others redirect it to table or error file. Let me know the result. Regards, YB

Follow the below steps to achieve the same, In your first lookup go to General , you find "specify how to macth error rows with no matching entries"Select Ignore FailureDo other lookup stuffs and select any key column in Available Output Columns (what your business suggests )In the 2nd lookup also go to General , you find "specify how to macth error rows with no matching entries" and make it to Ignore FailurePut a derived column and check for ISNULL(key_column)?,"error_description","" this will be your reject reasonPut a condition split and filter derived columns for null, reject_reason==""Insert records to a your table where reject reason is null and others redirect it to table or error file. Let me know the result. Regards, YB

You can have seven lookup components one after the other in sequence. On each of the lookup component set the property "Specify how to match error rows with no matching entries" to Ignore failure. This will move all rows, matched or unmatched to the next component. So you do not need a Union after each lookup component. Finally you can have a conditional split component to look at all the looked up values and create 2 outputs, one for all matched and the other for 1/more lookup failed. If you want to have a multi-lookup component , check this which is a "license paid for" component which allows you to do multiple lookups in a single step.http://btsbee.wordpress.com/

You can have seven lookup components one after the other in sequence. On each of the lookup component set the property "Specify how to match error rows with no matching entries" to Ignore failure. This will move all rows, matched or unmatched to the next component. So you do not need a Union after each lookup component. Finally you can have a conditional split component to look at all the looked up values and create 2 outputs, one for all matched and the other for 1/more lookup failed. If you want to have a multi-lookup component , check this which is a "license paid for" component which allows you to do multiple lookups in a single step.http://btsbee.wordpress.com/

Thank you so much Yogish this worked like a champ for me regards, Nandashree

Thyank you Regards, Nandashree