Data model optimisation

[zied_ahmed1]

Hello everybody,

I have this data model and i would like to minimize the number of tables

any suggestions ? thanks

[YoussefBelloum]

Hi,

to reduce the amount of tables (for optimization and aesthetic needs maybe) you can join many tables to your central table.

[YoussefBelloum]

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.

[jafari_ervin]

you should use dimensional model to optimize your data model.

[Venkatchoudary]

Try to use Applymap for 2-dimensional tables, as many as possible.

[Anonymous]

Try to Merge small tables into one table and you use apply mapping also.