Error ORA-00904 executing interface ODI
Hi,
i have one interface in Oracle Data Integrator to migrate one table from sqlserver to oracle
my LKM is "SQL to Oracle"
my IKM is "Oracle Incremental Updates"
when i execute my interface, generate the error : "ORA-00904: "S"."ID": invalid identifier" in step "Insert flow into I$ table"
the code is :
* DETECTION_STRATEGY = NOT_EXISTS */
insert /*+ append */ into MIGRASQL.I$_CO_CONCEPTO
(
DESCRIPCION,
IDPAIS,
IDCOMPANIA,
IDNATURALEZA,
IDCLASE
)
select
DESCRIPCION,
IDPAIS,
IDCOMPANIA,
IDNATURALEZA,
IDCLASE
from (
select C2_DESCRIPCION DESCRIPCION,
C3_IDPAIS IDPAIS,
C4_IDCOMPANIA IDCOMPANIA,
C5_IDNATURALEZA IDNATURALEZA,
C6_IDCLASE IDCLASE
from MIGRASQL.C$_0CO_CONCEPTO
where (1=1)
) S
where NOT EXISTS
i have one interface in Oracle Data Integrator to migrate one table from sqlserver to oracle
my LKM is "SQL to Oracle"
my IKM is "Oracle Incremental Updates"
when i execute my interface, generate the error : "ORA-00904: "S"."ID": invalid identifier" in step "Insert flow into I$ table"
the code is :
* DETECTION_STRATEGY = NOT_EXISTS */
insert /*+ append */ into MIGRASQL.I$_CO_CONCEPTO
(
DESCRIPCION,
IDPAIS,
IDCOMPANIA,
IDNATURALEZA,
IDCLASE
)
select
DESCRIPCION,
IDPAIS,
IDCOMPANIA,
IDNATURALEZA,
IDCLASE
from (
select C2_DESCRIPCION DESCRIPCION,
C3_IDPAIS IDPAIS,
C4_IDCOMPANIA IDCOMPANIA,
C5_IDNATURALEZA IDNATURALEZA,
C6_IDCLASE IDCLASE
from MIGRASQL.C$_0CO_CONCEPTO
where (1=1)
) S
where NOT EXISTS
0