31 table to create
Design order management data warehouse schema.(snowflake/ star schema) on azure sql
Will provide 31 tables sql file.
Look at the all table structure and pull out respective facts and dimension of that table on azure sql.
(We need proper indexing, partition on dimension and facts table.)
Also design all stored procedure views to populates that facts and dimension will call stored procedure in data factory.
Also create as tracking process of data push from staging table to schema facts and dimension table, last sync date time. (Audit table)
Stored procedure will be dynamic way which can handle parameters. Full push or incremental push from 31 tables.
Also design a process to push the schema on azure sql (Facts and dimension) to Azure analysis server. (Automation process)