MetaVault best practices

System extraction

• Do not execute hard rule or calculation in the query to extract data from the source system

DV Modelling

• Avoid creating a hub 'Period' except if this period data is part of the granularity of these data

Information Mart

• Use views containing virtual end dates (vsh or vsl) to extract data from a satellite at a correct time

• When you use a context satellite, it is recommended to filter on the src field

• If you use the context satellite of a link, it is not useful to join on context satellites for related hubs

• If you want to execute a left join on a link, do a left join on a sub select (with link & related hubs) instead