ODI Experts

The blog for Oracle Data Integrator

October 22, 2009
by Cezar Santos
11 Comments

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

Tags: ODI , ODI connection , ODI Context , ODI Data Server , ODI Experts , ODI Logical Schema , ODI Physical Schema , ODI PL/SQL , ODI repository , ODI Scenario , ODI sequence , ODI variable , ODI Web Services , Oracle Data Integrator , repositories , repository , Sunopsis

How to show Business Messages on Operator and, too, debug variables…

Hi Guys, I frequently got emails asking how to do show Business messages on OD and, as there isn’t such feature until version 10.1.3.5, I created a way to have it. It’s just like a magic trick! We will need … Continue reading →

September 10, 2009
by Kshitiz Devendra
5 Comments

Categories: ODI

Tags: ODI , ODI sequence

Sequence

Database Sequence Create a database Sequence in Oracle. create sequence test_sequence minvalue 2 maxvalue 999 start with 2 increment by 2 Map your interface Call the sequence in the respective column using this format <SCHEMA_NAME>.<SEQUENCE_NAME>.NEXTVAL TEMP.TEST_SEQUENCE.NEXTVAL TEMP - SCHEMA_NAME TEST_SEQUENCE … Continue reading →

Recent Posts Multi –Table Insert KM RKM FILE (Jython) Generate All Scenario for a Particular Project using ODI SDK Interface with Union, Minus Operator using ODI SDK Export and Importing Scenarios based on Project (or)Folder – ODI SDK	Recent Comments Ram on Creating Temporary Interface using ODI SDK Kshitiz Devendra on 11g Oracle Data Integrator – Part 4/11g – Upgrading from 10g Kshitiz Devendra on Changed Data Capture ( CDC ) Kshitiz Devendra on MINUS IN ODI Ram on 11g Oracle Data Integrator – Part 4/11g – Upgrading from 10g
Categories Administration Architecture Common Errors Drivers How to Java Codes Jobs Knowledge Modules Logic ODI ODI Bug Others Reports SDK SQL Technology Tips and Tricks	Tags Export file variable ODI Import Informix Interface INTERFACES Jython KM Knowledge Modules MINUS ODI ODI 11g ODI Adminstration ODI Agent ODI connection ODI Context ODI Data Server ODI Experts ODI Logical Schema ODI Physical Schema ODI PL/SQL ODI Procedure ODI repository ODI Scenario ODI sequence odisqlunload ODI variable ODI Web Services Operator Oracle Data Integrator Oracle Data Integrator 11g parallel PL/SQ Functions PL/SQL Parameters PL/SQL Procedures repositories repository scenario SDK Sql Sunopsis sysdate sysdate source UNION variable from file
Recent Jobs ODI Developer ODI Developer Oracle Data Modeler / ETL Developer with ODI / EDQ Exp	Blogroll askankit BI-Quotient john-goodwin