topic Re: SCD in Talend Studio

SCD

ZZoghlemi1703518476 — Fri, 15 Nov 2024 21:09:30 GMT

Please someone telling me what the difference between SCD type 2 component and SCD classic with Tmap without component

thanks

Re: SCD

Anonymous — Thu, 28 Dec 2023 01:38:58 GMT

Hello,

We usually use t<DB>SCD reflects and tracks changes in a dedicated DB SCD table.

Which types of update do you want to use?

If your dimension table is not very large, you can replace your SCD component with a tMap that accomplishes the same logic (two output tables-- one for updates one for inserts) by joining your input data to the dim table.

What your situation look like?

Here are online documentations about:

https://help.talend.com/r/en-US/8.0/scd/scd-scenario

https://help.talend.com/r/en-US/8.0/scd/scd-other

Hope it helps.

Best regards

Sabrina

Re: SCD

ZZoghlemi1703518476 — Thu, 28 Dec 2023 13:14:22 GMT

thanks very much xdshi "Sbarina"

that's helpful

Re: SCD

Anonymous — Mon, 08 Jan 2024 04:18:36 GMT

Hello,

Great it helps and feel free to let us know if there is any further help we can give.

Best regards

Sabrina