I would like to utilise FME to perform an update on a table a Slowly Changing Dimension (Type 2) . Where historical records are preserved, and you have Start, End dates and a Current flag for each record.
While the Change Detector transformer helps, it will still require some tricky manipulation.
I did find this article but can't see the detail...
It would be great if there was a ETL Transformer that could do this.
Any help would be appreciated.