ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

September 15, 2010
by Cezar Santos
6 Comments

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

Tags: , , , , ,

Single Post View


11g Oracle Data Integrator – Part 5/11g – odiConsole, the new Metada Navigator

Dear Friends, In ODI 10g we used Metadata Navigator to login which acted as Web portal to Trigger and view the listed Scenarios and also Light weight designer . In ODI 11g we have odiconsole which can be configured using … Continue reading

September 10, 2010
by Cezar Santos
8 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 31, 2010
by Cezar Santos
3 Comments

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

Tags: , , , , , ,

Single Post View


11g Oracle Data Integrator – Part 3/11g – Graphical User Interface

Hi Everyone… One more post in our “Oracle Data Integrator 11g” serie. In the last two features of the ODI 11g we have been covering the Initial and repository logic part . Now in this Post we will be covering few … 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
26 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 2024 | All Rights Reserved


Creative Commons License


Scroll to Top