topic Re: SCDELT component error: in Talend Studio

SCDELT component error:

Anonymous — Mon, 30 Apr 2018 23:15:20 GMT

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

Re: SCDELT component error:

Anonymous — Thu, 03 May 2018 10:24:30 GMT

Hello,

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

Best regards

Sabrina

Re: SCDELT component error:

Anonymous — Thu, 03 May 2018 16:58:05 GMT

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

Re: SCDELT component error:

Anonymous — Thu, 03 May 2018 19:10:43 GMT

@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,

Re: SCDELT component error:

Anonymous — Fri, 04 May 2018 04:34:06 GMT

Hello,

Let us know if it is OK with you.

Best regards

Sabrina

Re: SCDELT component error:

Anonymous — Fri, 04 May 2018 04:40:12 GMT

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.

Re: SCDELT component error:

Anonymous — Fri, 04 May 2018 10:42:23 GMT

Hello,

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

Best regards

Sabrina

Re: SCDELT component error:

Anonymous — Wed, 09 May 2018 00:56:27 GMT

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)

Re: SCDELT component error:

Anonymous — Thu, 10 May 2018 03:19:57 GMT

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

Re: SCDELT component error:

Anonymous — Mon, 25 Jun 2018 20:11:49 GMT

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.