| From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
|---|---|
| To: | Henrik Aagaard Sørensen <henrikaagaardsorensen(at)gmail(dot)com>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Implementing SCD Type 2. |
| Date: | 2013-04-02 22:26:07 |
| Message-ID: | 1364941567.74815.YahooMailNeo@web162904.mail.bf1.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Henrik Aagaard Sørensen <henrikaagaardsorensen(at)gmail(dot)com> wrote:
> I'm looking into implementing SCD Type 2 in PostgreSQL:
> http://en.wikipedia.org/wiki/Slowly_changing_dimension
>
> with the approach of having valid_from and valid_to fields in a table.
You might be interested in this recent thread:
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | JORGE MALDONADO | 2013-04-03 18:53:04 | 32 and 64-bit versions of PostgreSQL for Windows |
| Previous Message | Thangalin | 2013-04-02 20:50:36 | Re: Cannot create perlplu function |