ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

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

August 5, 2010
by Cezar Santos
7 Comments

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

Tags: , , , , , , , , ,

Single Post View


11g Oracle Data Integrator – Part 2/11g – Creating Repositories

Hello Dear Readers 😉 Nothing better to start our analysis that the real first step to start an Oracle Data Integrator 11g environment. It’s means REPOSITORIES! The visual interface is all new but the functionality is just the same… I liked … Continue reading

August 5, 2010
by Cezar Santos
3 Comments

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

Tags: , , , , , , , , ,

Single Post View


11g Oracle Data Integrator – Creating Repositories – Part 2/11g

Hello Dear Readers 😉 Nothing better to start our analysis that the real first step to start an Oracle Data Integrator 11g environment. It’s means REPOSITORIES! The visual interface is all new but the functionality is just the same… I liked … Continue reading

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


© Copyright 2024 | All Rights Reserved


Creative Commons License


Scroll to Top