ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

November 16, 2010
by Cezar Santos
0 comments

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

Tags: , , , , ,

Single Post View


11g Oracle Data Integrator – Part 7/11g – SUNOPSIS MEMORY ENGINE

Hello everyone. As this is a feature that comes from 10g but still present at 11g and pretty useful, we decide to discuss it as “11g part”. You will see that it’s really useful in several situations. We all have … Continue reading

October 6, 2010
by kdevendr
2 Comments

Categories: Administration , Architecture , How to , ODI

Tags: , , , , ,

Single Post View


Security Module – Main concepts and use

Hi Friends, We wrote this article to try to send some light on Security Module (10g for now) once several emails asked us for do it. I hope that it can be useful! The creation of users is relatively simple. … Continue reading

September 10, 2010
by Cezar Santos
7 Comments

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

Tags: , , , , ,

Single Post View


Using one of ODI’s lesser-known secrets: the Common Format Designer (CFD) – by Craig Stewart

Hi Reader, It’s a great pleasure starts a new “sector” from ODI Experts. It is our “Invited Experts” and we will start with one of the main ODI Guru in the world. Craig Stewart!!! Thank you Craig! Please, enjoy his post! … 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 26, 2010
by Cezar Santos
14 Comments

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

Tags: , , , , ,

Single Post View


IS_NUMBER (and IS_CHAR) at Oracle? A workaround…

Hi Friends, Right now I’m in São Paulo airport waiting for a flying that is very delayed! With some time free, let me write about something that I want to publish there is a long time…. Surprise! Isn’t an Oracle Data … Continue reading

August 25, 2010
by Cezar Santos
24 Comments

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

Tags: , , , , , ,

Single Post View


Calling OdiSqlUnload using ODI Procedure with no hardcoded password

Hello all, OdiSqlUnload is a great utility for unloading  but then we need to hardcoded and provide the parameters of the username and password which can change in the Other Environment in ( Testing , UAT or Prod ) . … 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


© Copyright 2018 | All Rights Reserved


Creative Commons License


Scroll to Top