Can I read Join vs. Lookup Stage in Datastage on EtoBox?

Join vs. Lookup Stage in Datastage by Veeru Java is a document available to read on EtoBox.

What is Join vs. Lookup Stage in Datastage about?

The document discusses the differences between the Join stage and Lookup stage in Datastage. The Join stage requires that input data be sorted on the key columns, supports inner, left outer, right outer, and full outer joins, and has light memory usage. The Lookup stage does not require sorted data, supports inner and left outer joins, and has heavier memory usage as it caches reference data in memory. The document provides examples of when each stage would be appropriate based on requirements like data vol

Author

Veeru Java

Language

EN