Blogs by Category:
Data Vault, dimensional, and data mart design patterns to structure analytics that scale.
November 3, 2026
KNA1, CUST_MSTR and tblClient are all your customers, and your warehouse still uses all three names. See how BimlFlex links tables to business entities and renames hundreds of them in one click.
October 14, 2026
When a relationship shows up before its hub row, or arrives with no key at all, the link load has to decide what to write. See the two SQL shapes BimlFlex generates for those cases and when each one fits.
October 12, 2026
BimlFlex keeps satellite loads append-only by default and can generate current and effectivity views on top. See both generated SQL shapes, what physical end dating adds to every load, and how to choose per satellite.
September 2, 2026
When a fact references a Type 2 dimension, BimlFlex generates a date range join that picks the dimension row that was true on the fact's effective date, and routes unmatched keys to the unknown member.
August 21, 2026
BimlFlex derives a bridge table's key from the traversal itself: the hub key plus every link key, hashed like any other Data Vault key. Missing legs get the zero key, and the generated load can only add rows, never change them.
August 18, 2026
A PIT load has to know where the last run stopped. BimlFlex derives that watermark from the PIT table itself: MAX of the snapshot dates, a lag-day overlap, and a floor that turns an empty table into a full rebuild.