topic tMSSqlSCD ELT in Talend Studio

tMSSqlSCD ELT

castiellll — Sat, 16 Nov 2024 05:25:26 GMT

Hello,

While monitoring a tMSSqlSCD component, we figured out that he generate a select * on the table. So, to avoid it, we would like to use a ELT component.

The problem is that I can't find a tMSSqlSCD ELT. Is there a place I can find it or a way I can run the SCD algorithm on the Sql engine ?

Thank you in advance.

Re: tMSSqlSCD ELT

Anonymous — Tue, 09 Jul 2019 04:06:29 GMT

Hello,

So far, there is no component tMSSqlSCDELT. Have you tried to use tJDBCSCDELT component to track data change in MSSql table?

Best regards

Sabrina

Re: tMSSqlSCD ELT

castiellll — Tue, 09 Jul 2019 08:50:41 GMT

Hello,

Thank you for your answer. I finally found a way to avoid that select * by checking these boxes :

Thnks