DataStage has three processing stages that can join tables based on the values of key columns: Lookup, Join and Merge.  In this post, we discuss when to choose which stage, the difference between these stages, and development references when we use those stages. Use the Lookup stage when: Having a …

In Informatica, Joiner and Lookup can both join tables according to the join keys. What are the difference between Joiner and Lookup? Joiner  Active Transformation The query cannot be overridden Works only for equal conditions Can do outer join Can use only as Source Multiple matches return all matching records …