I have 2 dimension table 1 fact table i need to join 3 tables?

[dolly777]

Hi All,

 How to joining 3 table have same field in common

Exm:

Table 1:

load
Cust_id,
Cust_Key,
Version,
Ins_date

Table 2:

load
Prod_id
Prod_Key ,
Version,
Ins_date

Table 3: (fact table)

load
Prod_id,
Report,
Cust_id,
Report_id,
Version,
Ins_date

[jonathandienst]

No, there is no need to join the tables. Do you really need the Version and Ins_date fields in your model, they look like audit fields only? If not, simply remove them from your load script.

If you do really need them, then add a qualify:

Qualify Version, Ins_date;

... your script as posted in your question (unchanged) ...

UnQualify *;