Lookup Join

Hi,

Can you tell me how work the component Lookup Join.

I think, that the component Lookup Join work as merge or can I this component use different with merge records from database.

Thanks

The LookupJoin works similarly to HashJoin - it uses pre-defined lookup table and joins all input records with records in the lookup table.

The advantage is that you may define internally lookup table - SimpleLookup/DBLookup/RangeLookup, populate it somehow in graph (using LookupReaderWriter) and then (in following phase) perform joining.