Best way dealing identical columns and multiple dates

[#1]

I came across scenario where we have identical columns on in diffrent tables and multiple date fields. i would like to know

  1. best way dealing with identical columns and at same time i want to a create master calender

Here is an example

[udit_kumar_sana]

Hi ,

Try to this with below link table concept:

Link_table:

load

Item as Link_table_Item,

Item_Desc as Link_table_Item_Desc,

Sales_dt as Link_table_dt,

Model as Link_table_Model

resident sales;


Concatenate


load

Item as Link_table_Item,

Item_Desc as Link_table_Item_Desc,

purchase_dt as Link_table_dt,

Model as Link_table_Model



resident purchase;



Concatenate


load

Item as Link_table_Item,

Item_Desc as Link_table_Item_Desc,

invoice_dt as Link_table_dt



resident Invoice;



Final_Link_table:


load


Link_table_Item &'-'& Link_table_Item_Desc &'-'&Link_table_dt as Key,

Link_table_Item,

Link_table_Item_Desc,

Link_table_dt,

Link_table_Model

resident Link_table;

drop Table Link_table;

-Form this key in your each individual tables also.

-and comment the Item,Item_Desc,dt,Model in each individual table.

-Use this dimensions from linktable created i.e.

Link_table_Item,

Link_table_Item_Desc,

Link_table_dt,

Link_table_Model

Regards,

Udit

[#3]

Im still seeing sync key's, is this normal ?

[udit_kumar_sana]

Hi,

-Form this key in your each individual tables also.

-and comment the Item,Item_Desc,dt,Model in each individual table.

Regards,

Udit

[#5]

Please find the attached , hope it helps

[#6]

I can avoid sync key, but how do i achieve building master calender by using your model. What i was thinking , CONCATENATE all common fields and create a link table. But im not sure if it is a optimal model.