One Example For Substitution Methods
Procedure Details for Loading Data from a Remote SQL Database
| Source Technology | Oracle |
| Source Logical Schema | SOURCE |
| Source Command | select ENAME V_ENAME,EMPNO V_EMPNO from <%=odiRef.getObjectName("L","SCOTT","D")%> |
| Target Technology | Teradata |
| Target Logical Schema | TERADATA_DWH |
| Target Command | insert into PARTS (ENAME,EMPNO) values (:V_ENAME,:V_EMPNO) |
No comments:
Post a Comment