Generic SCD Without Using Component and to any tables

[ali_elamin]

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

[Anonymous]

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