I have two sql tables one containing dimension and other expression

[#1]

Hello,

How do I merge both table to ensure a smooth association of all my expression to my dimension. These is a key field from both table how do I resolve this?

Regards

Ema

[maxgro]

I suppose you want to associate the tables by ProductKey only

Remove LastModified from the two SQL select in your script

[#3]

Hello,

I want the products in dimension table to be associated with all the fields in expression table.

Rgds

[#4]

Productkey seems like good enough key field between your fact table and dimension table and you dont want to have that "lastmodifed" column disrupting your data, rename them. table.field or however you like it.

Cheers!

[#5]

Hello,

I want the products in dimension table to be associated with all the fields in expression table.

Rgds

Well, they will. one unique key field between two tables is enough. If you think there should be more keys between two tables as per business logic concatenate them into one single key.