Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Building and Updating Time-Variant Bridge Table

Go down

Building and Updating Time-Variant Bridge Table Empty Building and Updating Time-Variant Bridge Table

Post  Bigguy365 Mon Feb 24, 2014 10:39 am

Warren Thornthwaite “Design Tip #142 Building Bridges” article demostrated the creation of a simple static bridge table to reduce the number of entries in the bridge table by identifying the distinct combinations of natural key present and assigning each combination a group key.  His article also indicated and I quote "this approach can be extended to support the more complex time-variant bridge table".  I currently have a requirement that would require a time-variant bridge table that is pointing to a dimension that contains type 2 columns.  Are there resources available that can guide me with the design and implementation to address this complex task?

Thanks you,

Bigguy365

Bigguy365

Posts : 1
Join date : 2014-02-24
Age : 74
Location : Melbourne, Florida

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum