Home > Software > Data-Warehouse > DataStage
Interview Questions   Tutorials   Discussions   Programs   Discussion   

DataStage - What is the difference between lookup stage reject link and merge stage reject link in data stage Parallel jobs?




632
views
asked mar September 20, 2014 06:31 AM  

What is the difference between lookup stage reject link and merge stage reject link in data stage Parallel jobs?


           

1 Answers



 
answered By vishnoiprem   0  

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.

flag   
   add comment

Your answer

Join with account you already have

FF

Preview


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!

Alert