ODI Training in banalore , Oracle Data Integrator 11G and 12C Online Training
Oracle Data Integrator 11G and 12C Online Training
Tuesday 18 September 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 12 September 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 11 September 2012
CDC (Changed Data Capture ) in ODI step by step
Monday 10 September 2012
DATA SETS Step by Step IN ODI 11g
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)