How can I avoid Sync in this example?

[camilo]

Hi, I´m loading two tables but I´m getting syn tables ¿How can I avoid this?

LOAD [Local SAP],

     [Id SAP] as ID,

     [Departamento SAP] as Departamento,

     Month(Dia) as Mes,

     Year(Dia) as Año,

     Dia as Fecha,

     [Unidades Vendidas],

     [Venta Neta $]/1000000 as Venta,

     [Costo Venta $]/-1000000 as Costo

FROM

(qvd);

LOAD Fecha,

     id_local_int as ID,

     ID_Categoria,

     Venta/1000000 as VentaP,

     [Margen dia]/1000000 as MargenP,

     Month(Fecha) as Mes,

     Year(Dia) as Año,

FROM

(qvd);

Thanks!

[klausskalts]

Concatenation IS a possible solution ... but it's normally better to create a keyfield yourself

Field_no1 & '-' & Field_no_2 as Key

in both tables ....

[Anonymous]

Hi Klaus, If I have more than six table where I need to link all the column to a common key name, so what is good appraoch to avoid the sync key. whether to concatenation or making a common key in all the table, ex: Table1, TB1_Business_Source, as Key Table2, TB2_Business_Source as Key Table3, TB3_Business_Source as Key Table4, TB4_Business_Source as Key Table5, TB5_Business_Source as Key  Table6, TB6_Business_Source as Key Need help Best Regards,

[#4]

Hi S Kumar,

I think if you are not ending up with a bunch of null values. give a atry to concatenation or else its always better to go for a composite key.

Its also depends on size of tables which you are having. If concatenation is increasing your tables size drasticlly go for Composite keys.

Hope this helps

thanks

Meher.