tMSSqlSCD ELT

[castiellll]

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.

[Anonymous]

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

[castiellll]

Hello,

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

Thnks