Home

OLL Mobile

FAQ

ODI11g: Creating an ODI Project: Developing an ODI XML to Database Transformation Using Interface with ODI Constraint

    • Rating:

General Information

  • This OBE tutorial describes and shows you how to create an Oracle Data Integrator (ODI) interface that will import an XML file into a database table CLIENT. This process also involves adding an ODI constraint to the CLIENT model. Any records that do not pass the constraint will be loaded to the E_CLIENT table.

    Release Date: 11-Jan-11

    Duration: 40 minutes

    Credited To: Viktor Tchemodanov

    No Flash Plugin Needed

Reviews

  • iravdb

    24-Jun-14

    Had to change the expression of the age_constraint using this conversion: TO_NUMBER(CLIENT.AGE , '99.9)

  • igorburtsev

    05-Jun-13

    1) For ODI 11.1.1.7 instead of: /demo/xml/GEO_DIM.xml&re=GEOGRAPHY_DIM&ro=false&case_sens=true use: jdbc:snps:xml?f=\xml\GEO_DIM.xml&re=GEOGRAPHY_DIM&ro=false&case_sens=true for sample: jdbc:snps:xml?f=C:\odi_demo\xml\GEO_DIM.xml&re=GEOGRAPHY_DIM&ro=false&case_sens=true 2) Instead of: RDBMS_TARGET > CLIENT > Constraints > CITY Copy of CITY_CLIENT read: RDBMS_TARGET > CLIENT > Constraints > CITY

  • lgalvez

    20-Feb-12

    -

  • krishnamoorthy.d

    19-Oct-11

    -

Tags

Visit the Full Site | About Oracle | Contact Us | Terms of Use