Reuse Data Models to Build other data models.
PROBLEM:
Currently, we build data models that contain a set of tables (data model for products, data model for financial information); but these tables can have relationships between them too (EG: product tables can have a relationship with financial data). If we want to create a data model that contains both product and financial information into 1 data model, we have to recreate it from scratch.
QUESTION:
Is there the ability to create a data model by using the existing data model. EG: create a single data model that uses as a source the data model of products and financial information.
1 reply
-
Hi
Take your data flows for the products and finance models and change the target so that they write their tables of data to the same database. These models will work then as is using each model to define the tables used for that model, but residing in the same DB.
Then create a Direct Query model to that DB and use the combination of Product and Finance tables you require.
Hope that helps.
Ian