Generic SCD Without Using Component and to any tables

ali_elamin — Sat, 16 Nov 2024 04:30:44 GMT

hello

i want to make a SCD works with any tables (without determine the schema ) ,

i want to tracking the changing between any source an dimension as i don`t know the table`s columns without using SCD component and making a thing like audit table with the start and end time of the row and an flag to it

Thanks in Advance

Re: Generic SCD Without Using Component and to any tables

Anonymous — Tue, 01 Oct 2019 15:41:39 GMT

Hi,

You can try Dynamic schema to do processing independent of schema details. But it is having some restrictions as mentioned in the help document.

https://help.talend.com/reader/9NRa~CylzTWZ8bFvUjlang/yJ3uVEzDciOxdy9B9G1tBw

Your use case is schema and table independent and this use case will need custom coding.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

topic Generic SCD Without Using Component and to any tables in Talend Studio

Generic SCD Without Using Component and to any tables

Re: Generic SCD Without Using Component and to any tables