Oracle Data integrator 11G & 12c Tutorials,
Oracle Data integrator 11G & 12c Tutorials,
Tuesday, September 18, 2012
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;
Wednesday, September 12, 2012
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
Tuesday, September 11, 2012
CDC (Changed Data Capture ) in ODI step by step
Monday, September 10, 2012
DATA SETS Step by Step IN ODI 11g
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)