create fact table

[#1]

please download the attachment

and allow me to know .how to create fact table of these dimensions  table

thanks in advance

[Peter_Cammaert]

There is just master data in your three tables, meaning that they translate into dimensions. But the facts come from different tables (missing in your picture) like sales records, or customer calls, or shipments. Do you have any tables like that?

[pokassov]

Fact:

NoConcatenate Load

     *

resident

User;

Left Join (Fact)

Load

  *

Resident

  Target;

Left Join  (Fact)

Load

  *

Resident

  TargetClient;

DROP  Tables

  User, Target, TargetClient;

[buzzy996]

there is no fact data in ur table ,whichever u shoed all are the dimension data.

in simple words,

facts means measure's(keys to help understand the business)