Four Stars

Using Postgres SCD

Hi,

 

I am new to Talend and  have a requirement where I have to track the number of changes to a source column value. I am thinking of using SCD (Postgres) component for this but I can't seem to wrap my head around how I would do that. Is there a way to maintain a counter on the target table that can be incremented every time a column in the source changes? 

 

 

Thanks! 

Tags (1)
1 REPLY
Moderator

Re: Using Postgres SCD

Hello,

Please take a look at SCD management methodology in this component reference:https://help.talend.com/reader/2tiSun_vbOrd1lzUGhonSQ/SSe32W6RpDY6F7fbQ1~J0w.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.