Using Postgres SCD

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! 

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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now