1) After clicking on discover and auto-generated model, how can we change the name of the table that will be populated in data warehouse?
2) I don't want to model by Data Vault because the custom model is already designed for data warehouse. How can i build a custom model with no hubs and satelittes?
3) According to my custom model, there are 3 data warehouse tables that are being generated from single target table. Will it be done in mapping but how?
These prefix and suffixes can be changed in the project settings.
2) Compose populates the type-1 (SCD - Slowly changing dimensions) attributes data into hub tables and type-2 (SCD) attributes data into Satellite tables. Compose designs both attributes into separate tables but not into a single table
3) Same table from landing DB can be used as source for different data warehouse tables. select the table in the mappings of the three data warehouse tables.
