Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Im still seeing sync key's, is this normal ?
Hi,
-Form this key in your each individual tables also.
-and comment the Item,Item_Desc,dt,Model in each individual table.
Regards,
Udit
Please find the attached , hope it helps
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.