ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

January 17, 2011
by Cezar Santos
7 Comments

Categories: Administration , Common Errors , How to , ODI , ODI Bug

Tags: , , , , ,

Single Post View


Jython Scripts fails to recognize the module during scenario run in ODI 11g

Hi Friends! 2011… we are back! 😉 During a recent Oracle forum question i was looking at an interesting question where the user said the ODI Scenarios throws the error ‘ No module names re ‘ . Initially i thought … Continue reading

August 28, 2010
by kdevendr
0 comments

Categories: Administration , Common Errors , How to , Logic , ODI , Technology , Tips and Tricks

Tags: , , , , ,

Single Post View


Datatypes – Creating what is missing for any technology

Hi Guys, Another really usefull tip about data types! There are some time it happens we don’t have the required data type in respective Technology in ODI say for example DATETIME YEAR TO DAY ,DATETIME YEAR TO SECOND etc and … Continue reading

August 19, 2010
by Cezar Santos
12 Comments

Categories: Administration , Architecture , Common Errors , ODI , ODI Bug , Tips and Tricks

Tags: , , , , , , ,

Single Post View


SNP_EXP_TXT – A “huge” table problem

Hi People, There is a “bug” in Oracle Data Integrator that doesn’t clean the SNP_EXP_TXT when the “parent” records are deleted. That happens because, in the repository data model, there is no FK between the SNP_EXP_TXT and its several parents table exactly … Continue reading

October 30, 2009
by Cezar Santos
7 Comments

Categories: Architecture , Common Errors , Logic , ODI , Tips and Tricks

Tags: , , , , , , , , , , , , , , ,

Single Post View


Subscribers – An example of how to use

Hi friends, I was helping in a thread at ODI Forum, from Oracle page (http://forums.oracle.com/forums/forum.jspa?forumID=374) and I decided to describe the situation here once several people ask me similar questions What is a Subscriber and how to use it? A … Continue reading

September 9, 2009
by Cezar Santos
3 Comments

Categories: Common Errors , ODI , Tips and Tricks

Tags: , , , , , , ,

Single Post View


How to get a constant or pseudo-column from source mapping

Hi, Let me show you a small trick when is necesary to obtain some psedo-column (like rowid) or database function (like sysdate) . If a direct mapping of those values is done, a error like this will happens: For bypass … Continue reading


© Copyright 2017 | All Rights Reserved


Creative Commons License


Scroll to Top