topic Re: implementation of Toraclecdc in Talend Studio

implementation of Toraclecdc

Anonymous — Fri, 08 Jun 2018 07:52:46 GMT

Hi,

Can anyone explain toraclecdc implementation with example.

Thanks.

Re: implementation of Toraclecdc

manodwhb — Fri, 08 Jun 2018 07:54:36 GMT

@MahendraReddy,did you verified below link?

https://help.talend.com/reader/NNO~fmVQU4rlkF9Depfdxw/JXvgNTorRK1zf3XyoitGag

Re: implementation of Toraclecdc

Anonymous — Fri, 08 Jun 2018 07:56:18 GMT

But i couldnt get any solution

Re: implementation of Toraclecdc

Anonymous — Fri, 08 Jun 2018 07:59:05 GMT

yes but i couldnt get any solution

Re: implementation of Toraclecdc

Anonymous — Fri, 08 Jun 2018 08:04:42 GMT

Hello,

Have you checked the related senarios in this component reference?

TalendHelpCenter: Scenario 1: Populating a data warehouse and TalendHelpCenter: Scenario 2: Retrieving modified data using Oracle CDC Redo log mode

What is your issue when try to use tOraclecdc?

Best regards

Sabrina

Re: implementation of Toraclecdc

Anonymous — Fri, 08 Jun 2018 08:12:22 GMT

ORA-04098: trigger 'SCOTT.TCDC_TG_T00002' is invalid and failed re-validation
ORA-04098: trigger 'SCOTT.TCDC_TG_T00002' is invalid and failed re-validation
ORA-04098: trigger 'SCOTT.TCDC_TG_T00002' is invalid and failed re-validation
[ERROR]: local_project.job1_1_0_1.Job1_1 - tOracleOutput_1 - ORA-04098: trigger 'SCOTT.TCDC_TG_T00002' is invalid and failed re-validation

[ERROR]: local_project.job1_1_0_1.Job1_1 - tOracleOutput_1 - ORA-04098: trigger 'SCOTT.TCDC_TG_T00002' is invalid and failed re-validation

[ERROR]: local_project.job1_1_0_1.Job1_1 - tOracleOutput_1 - ORA-04098: trigger 'SCOTT.TCDC_TG_T00002' is invalid and failed re-validation
Exception in component tOracleCDC_1 (Job1_1)
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

this is the error which iam getting