ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

November 12, 2010
by Cezar Santos
9 Comments

Categories: How to , Logic , ODI , Tips and Tricks

Tags: , , , , , , ,

Single Post View


11g Oracle Data Integrator – Part 6/11g – Union , Minus, Intersect

Hello Friends , We have shows you few important features of the new ODI 11g ,today we are going to show you how to implement Union , Minus etc logic in ODI 11g which was lacking in older version and … Continue reading

March 23, 2010
by kdevendr
1 Comment

Categories: How to , Knowledge Modules , Logic , ODI , Tips and Tricks

Tags: , ,

Single Post View


KM FOR UNION BASED ON IKM SQL CNTRL APPEND

This KM is do UNION in ODI  which created based on IKM SQL Control Append and support Flow control too and is based on the full outer join concept Map the column in this format NVL( <SOURCE1.COLUMN1 , SOURCE2.COLUMN1> NVL(<SOURCE1.COLUMN2,SOURCE2.COLUMN2> … Continue reading


© Copyright 2018 | All Rights Reserved


Creative Commons License


Scroll to Top