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

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 25, 2010
by Cezar Santos
23 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 2017 | All Rights Reserved


Creative Commons License


Scroll to Top