Clear all

Virtual Information Mart Layer

Posts: 28
Topic starter
Joined: 2 years ago

Hi all,

What approach have you seen or used to virtualize downstream layers from the Raw Vault?

Main issue: querying full change history across Satellites across Hub entities. 


Hub A -> Sat AA, Sat AB, Sat AC

Hub B -> Sat BA, Sat BB

Question 1: The developer needs to combine Entity A and Entity B together, providing full change history across the 6 Satellites, all with varying change timestamps. How to do this most efficiently and accurately?

Partial Solution: I have created, for those Hubs with multiple Satellites, an entity that stores the distinct LOADTIMESTAMP across Satellites attached to a single Hub.  This is a convenience entity and can be done via a View as well. This provides single-entity change history.

Question 2: If we only select a few attributes from each Satellite, how do we condense the change history to reflect changes to only those attributes?  Essentially generating a history of just those attribute changes


HK / AttributeA / Date

123 / ABC / 2021-01-01

123 / ABC / 2021-01-15  <-- this record should be excluded

123 / XYZ / 2021-02-01

123 / ABC / 2021-02-03


Looking for "virtualized" answers.  

Thanks in advance!

12 Replies