|
|
|
|
|
|
by trengrj
2842 days ago
|
|
|
If you store your data in a slowly changing dimensional format you will be able to create a table where you can query the data as it was at any point of time. The easiest way to do this is to use an ETL tool as hand coding this can be a bit hairy. You can use an open source etl tool like Talend for this as it has inbuilt Postgres or MySQL scd modules. |
|
|