Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
I have this data model and i would like to minimize the number of tables
any suggestions ? thanks
Hi,
to reduce the amount of tables (for optimization and aesthetic needs maybe) you can join many tables to your central table.
as soon as you understand the meaning of each of these tables, there is a lot of work that must be done here, in fact I think the tables were loaded without modeling at all.
you should use dimensional model to optimize your data model.
Try to use Applymap for 2-dimensional tables, as many as possible.
Try to Merge small tables into one table and you use apply mapping also.