Resolve syntatic key

[mfcelleri]

I need to resolve this syntatic key. I need to calculate the number of clients for each vendor (count client for vendor).

In the actual diagram I don't know how to do this.

[JordyWegman]

Hi,

Please read this article on synthetic keys. 

Your solution is renaming all the fields in your tables (quality of low of the image so I can't really read it well):

• Vendeoor
• Empressa
• LineaP

Don't do this in the table Facturacion, but in the other tables where this is stored.

Jordy

Climber

[mfcelleri]

Hi Jordy;

And what about the relationships between those tables (Vendedor, Empresa, LineaP) and the Facturacion table.

[JordyWegman]

You should bring them under one key or join the data into one table.

Can you show the script that is used for these tables?

Jordy

Climber

[mfcelleri]

Hi Jordy;

This is part of my load script.