SCDELT component error:

Six Stars

SCDELT component error:

I'm using postgresql ELTSCD component. Its throwing an SQL error on a simple job.

the aliasing happens internally, I'm not sure what is this error pointing at.

 

Position: 46
org.postgresql.util.PSQLException: ERROR: syntax error at or near "d"
Position: 46

 

Please see the screenshots for more understanding


Accepted Solutions
Six Stars

Re: SCDELT component error:

It crazy, but I think the issue is with the component when I try to use it for redshift database.

 

Now instead I use JDBCSCDELT component which works.


All Replies
Moderator

Re: SCDELT component error:

Hello,

tPostgresqlSCDELT is used as an output component. It requires an input component and Row main link as input.

 

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: SCDELT component error:

I'm unable to connect row main tpostgresqlELTmap to this component. Hence I thought this component works on its own.
Six Stars

Re: SCDELT component error:

@xdshi  this postgresqlSCDELT component can't be connected from any ELTpostgresinput/output components. 

I've tried using it with tpostgresqlinput its throwing the same error. I was reading more on this component(below link) & on the "Source table" it says 'Name of the input DB2 SCD table'.

Can this be used for postgresql to postgresql tables?

may I know if there is an example to use any of the SCDELT components?

 

https://help.talend.com/reader/vfw2NwIrrNsiOsXIVOrdvA/3d25u8G5ZEd0oCA1Y62~yw

 

warm regards,

SK

Moderator

Re: SCDELT component error:

Hello,

Here is a related scenario about:TalendHelpCenter:Creating a Job for tracking data changes in MySQL using SCD.

Let us know if it is OK with you.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: SCDELT component error:

Hi,
I'm looking for ELTSCD, this is an ETL process in the example. I know how this component works. I'm looking for ELT.
Moderator

Re: SCDELT component error:

Hello,

Currently, there is no a scenario for ELTSCD. Have you tried to use tfixedflow-->tPostgresqlSCDELT to see if it works?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: SCDELT component error:

Yes I tried, I have reached out to Talend support to send me an sample job for using this component.

I figured that this component works independently with out any input link from their job.

 

I tried to implement the same, the error still persists. I wonder if the issue is with the component in this version of talend (Talend  integration cloud Saas 6.5.1.20180116)scd error.PNGscd error 1.PNG

Moderator

Re: SCDELT component error:

Hello,

Could you please check your "Code" tab in your job to see will there be your compile error highlighted in red line? Have you already created a case on support portal about your SCDELT component issue?

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: SCDELT component error:

It crazy, but I think the issue is with the component when I try to use it for redshift database.

 

Now instead I use JDBCSCDELT component which works.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download