Zitat von Thiemo Kellner <thiemo@xxxxxxxxxxxxxxxxxxxx>:
Hi LukaszI am working on a generic (reading the information schema and other database metadata), trigger based solution for SCD tables, i. e. tables that keep (or not according to SCD type) history of the data. However, it is not far grown and I am not having much time to advance it so it evolves very slowly. If you are interested, I would open a sourceforge project or the like and we can work on it together.I am very much surprised that no database I know of supports SCD/historising tables out of the box. In 16 years as ETL pro I have seen reinvented the wheel all the time... maybe PostgreSQL wants to get a head start on this.Kind regards Thiemo
-- +49 (0)1578-772 37 37 +41 (0)78 947 36 21Öffentlicher PGP-Schlüssel: http://pgp.mit.edu/pks/lookup?op=get&search=0x8F70EFD2D972CBEF
---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.
Attachment:
full_install.7z
Description: Binary data