ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

October 22, 2009
by Cezar Santos
13 Comments

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

Tags: , , , , , , , , , , , , , , , ,

Single Post View


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 kdevendr
15 Comments

Categories: ODI

Tags: ,

Single Post View


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

September 9, 2009
by Cezar Santos
3 Comments

Categories: Common Errors , ODI , Tips and Tricks

Tags: , , , , , , ,

Single Post View


How to get a constant or pseudo-column from source mapping

Hi, Let me show you a small trick when is necesary to obtain some psedo-column (like rowid) or database function (like sysdate) . If a direct mapping of those values is done, a error like this will happens: For bypass … Continue reading


© Copyright 2018 | All Rights Reserved


Creative Commons License


Scroll to Top