how to remove synthetic key by composite key

[#1]

by using composite key how to remove synthetic key

[#2]

Hi,

If you see answer by ashfaq, It uses two columns to create a composite key.

How to remove synthetic key?

Thanks,

Abhishek

[Gabriel]

Hi,

You can create a composite key which helps with removing syn key. Then you have to think of what you want to do with other fields causing Syn Key. You have several options, renaming these field or dropping them if they're not needed.

Hope this helps

[awhitfield]

Have you got a sample qvw you can post?

Andy

[Anonymous]

Composite key combine your multiple keys in single column

you can also use LINK table .