Logic of getting Multiple Files and processing one by one through a common Interface. Continue reading
Monthly Archives: September 2009
Generate Multiple Scenarios
Right click on the Folder – > Generate All Scenarios… Select the required option and click ok to apply the settings.
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: constant source , ODI , ODI Experts , ODI sequence , Oracle Data Integrator , Sunopsis , sysdate , sysdate source
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
Lock Windows Layout
To Lock the Windows Layout in Designer, Operator, Topology and Security Manager from moving , check mark option ” Lock windows Layout ” Topology – > Windows – > Lock Windows Layout .
Hide Unused Technologies
To see only the list of Technologies used in Topology and Designer , check mark option ” Hide Unused Technologies ” Topology – > Windows -> Hide Unused Technologies
Tab at the Top
To have the Tab at the Top in Designer, Operator, Topology and Security Manager , check mark option ” Tab at the Top ” Topology – > Windows -> Tab at the Top Revert back the option to have Tab … Continue reading
oracle.jdbc.V8Compatible
When loading the data for ODI 10g and using the Oracle 10g driver , For columns with “DATE” data type, only the date is captured and the hours, minutes , second are marked as 00.00.00 or Not shown at all. … Continue reading
Oracle to Flat file
This is the Sample of source Table to be populated as Flat File. Target [Flat File – region.dat] 1. Go to the Physical architecture of the Topology and insert a New Data Server under File Technology 2. For the JDBC … Continue reading
Scheduling using ODI Scheduler
Start the agent using agent scheduler or agent service Scheduling process Under the scenario , right click on scheduling , click on ” Insert scheduling ” Define all the scheduling parameter and the logical agent and log level. Set the … Continue reading