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.
org.postgresql.util.PSQLException: ERROR: syntax error at or near "d"
Please see the screenshots for more understanding
Solved! Go to Solution.
tPostgresqlSCDELT is used as an output component. It requires an input component and Row main link as input.
@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?
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.
Currently, there is no a scenario for ELTSCD. Have you tried to use tfixedflow-->tPostgresqlSCDELT to see if it works?
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 184.108.40.20680116)
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?
Watch the recorded webinar!
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.