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
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.