IICS Tutorial_18 Incremental Data Loading using IICS Input-Output Parameters

Показать описание

*Script to create source table */
CREATE TABLE EMPLOYEES_SRC ( EMPLOYEE_ID NUMBER(6,0), NAME VARCHAR2(20 BYTE),SALARY NUMBER(8,2),CREATED_DATE TIMESTAMP DEFAULT SYSTIMESTAMP, MODIFIED_DATE TIMESTAMP DEFAULT SYSTIMESTAMP );
INSERT INTO EMPLOYEES_SRC(EMPLOYEE_ID,NAME,SALARY) VALUES(1,'John',1002);
INSERT INTO EMPLOYEES_SRC(EMPLOYEE_ID,NAME,SALARY) VALUES(2,'Michael',1200);
INSERT INTO EMPLOYEES_SRC(EMPLOYEE_ID,NAME,SALARY) VALUES(3,'Nicolas',60);
INSERT INTO EMPLOYEES_SRC(EMPLOYEE_ID,NAME,SALARY) VALUES(4,'Peter', 4440);
INSERT INTO EMPLOYEES_SRC(EMPLOYEE_ID,NAME,SALARY) VALUES(5,'Brienne',6100);
INSERT INTO EMPLOYEES_SRC(EMPLOYEE_ID,NAME,SALARY) VALUES(6,'Pat',7500);