Model Solution

[fkeuroglian]

Hi Expert

I have this situation with a model, what would be the best solution?

i think about a link table, i can delete any field of this tables

thank you a lot

Fernando

[Anonymous]

i would concatenate the targeta and detalle table into one fact table

[#3]

The better way is concatenate the table, It is more performance than Linktable.

Regards

Marcos Freire

[Anonymous]

Hi Fernando,

Maybe you can join the tables and make them into one fact table. The table REMITO can serve as a dimension. This will than be connected to the fact table by concatinating the to fields and making them a key. You would do the same on the fact table. So something like: (PROD_SQ_COD & 'I' & TARJ_SQ_COD) as %REMITO_KEY