Excel to oracle data base loading data in Oracle Data Integrator

Loading Data From XML file to SQL database

Knowledge modules: LKM SQL and IKM SQL Control Append or incremental update.

Generating XML data file using SQL.

SELECT DBMS_XMLGEN.GETXML('select * from emp') FROM DUAL;

Two source tables to one target table interface example

Create one table for combination of both emp and dept tables.



CREATE TABLE EMP_DEPT AS
  (SELECT E.EMPNO,
      E.ENAME,
      E.JOB,
      E.MGR,
      E.SAL,
      E.HIREDATE,
      E.COMM,
      E.DEPTNO,
      D.DNAME,
      D.LOC
    FROM SCOTT.EMP E,
      SCOTT.DEPT D
    WHERE E.DEPTNO=D.DEPTNO
    AND 1=2
  );

ODI Sample Resume

CDC (Changed Data Capture ) in ODI step by step

DATA SETS Step by Step IN ODI 11g