Once the data is loaded to Data Vault tables, Has anyone used Denodo for creating virtual dimensions and facts?
There is an option to cache on denodo. I plan to use cache in denodo for the PIT and BRIDGE tables instead of creating physical table structures and writing ETL to load the PIT and BRIDGE physical tables.
Would like to check if anyone tried it and faced any challenges with such approach?
Any leads to other reading material is also welcome