Friday, February 1, 2013

Difference between Joiner and Union Transformation



  • Joiner Transformation can join only two input groups whereas Union Transformation can join multiple input groups
  • Joiner Transformation combines the records horizontally based on the join condition whereas Union Transformation joins the records vertically
  • Joiner Transformation supports Normal join, Master outer join, Detail outer join and Full outer join whereas Union Transformation does UNION ALL
  • Joiner Transformation removes duplicates whereas Union Transformation doesn't   
Both these transformation supports heterogeneous joins(Join between two different data sources Ex: Oracle + SQLServer)
Posted by
Labels: ,

3 comments:

  1. UnknownNovember 16, 2015 at 2:21 AM

    Very Excellent site for obiee

    ReplyDelete
  2. UnknownJune 22, 2016 at 9:51 AM

    Valuable information thanks for sharing OBIEE ONLINE TRAINIG

    ReplyDelete
  3. itguruJuly 16, 2026 at 10:20 PM

    Develop job-ready integration skills with Workday Integration training online, featuring live instructor-led classes, hands-on labs, real-time projects, certification guidance, and placement assistance.

    ReplyDelete

Subscribe to: Post Comments (Atom)
Related Posts Plugin for WordPress, Blogger...