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