ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

August 3, 2010
by kdevendr
9 Comments

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

Tags: , , , , ,

Single Post View


Regenerate ODI Objects using OdiGenerateAllScen

Hi, One more little trick! ODI objects such as Packages, Interface, Variable and Procedure scenarios can be regenerated without manually regenerating individual scenarios using OdiGenerateAllScen. Drag in the OdiGenerateAllScen and select the Project and select Yes to Generate Package Scenarios … Continue reading

April 12, 2010
by Cezar Santos
21 Comments

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

Tags: , , , , , , , , ,

Single Post View


Getting one or several unknown files from a directory

Hi Friends… Today I would like to share with you a way that I have been using for several years, to get unknown files from a directory in Oracle Data Integrator. For instance, if you have files in a directory … 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 2024 | All Rights Reserved


Creative Commons License


Scroll to Top