Merge stage : The parallel job stage that combines data setslookup stage: The mainframe processing jobs and parallel active stages that perfom table lookups. Lookup stage:1. Used to perform lookups.2. Multiple reference links, single input link, single output link, single rejects link, single primary link. 3. Large amount of memory usage. Because paging required5. Data on input links or reference links need NOT to be sorted. Merge stage:1. Combines the sorted data sets with the update datasets. 2. Several reject links, multiple output links will be exist. 3. Less memory usage.4. Data need to be sorted.
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!