How to refresh table metadata in the data mart layer?
Hi,
I have a transformation layer before by data mart layer. In my transformation layer, I've made some changes to the data types in the fact table. I already recreated the table in transform so everything is good in the transformation layer.
Now in my data mart layer, I see no way to allow these datatype changes to be propagated to the facts table without removing the facts table and adding it back in. This method requires me to then recreate the model and recreate the tables.
Is there a way to allow the datatype changes from the previous layer to be propagated to the tables in the data mart layer without having to remove the table and adding them back in?