topic Re: How to Remove the Synthetic Keys in App Development

How to Remove the Synthetic Keys

asb02512 — Sun, 11 Dec 2016 12:31:15 GMT

Dear all.

Please help me and guide me regarding the synthetic key issue. i am a newbie. Please find the attached image, I am getting the desired result but the issue is of synthetic keys. I dont know where i am doing the mistake renaming or qualify and unqualify. How to remove the synthetic keys in the current scenario.

Re: How to Remove the Synthetic Keys

shraddha_g — Mon, 12 Dec 2016 03:28:24 GMT

Create a composite key of BRANCH_CD and CUST_SALESMAN to link Table Branches and Customer to Monthly_Sales_Activity. 2nd Key will be VNDR# and ITEM# to link Table Vendor and ITEM Master to Monthly Sales Activity.

Re: How to Remove the Synthetic Keys

shaktisinghchau — Mon, 12 Dec 2016 03:54:49 GMT

To minimize or remove synthetic key you can concatenate the fields which is causing synthetic key like I did below.

BRANCH_CD & '|'& CUST_SALESMAN AS Key

Re: How to Remove the Synthetic Keys

jonathandienst — Mon, 12 Dec 2016 04:59:08 GMT

Firstly - synthetic keys are not an evil that needs to be eradicated, they are a valid and efficient way to handle composite keys (association keys made up of more than one field).

In your case, you would need to decide if the association between customer and monthly sales activity should be a salesman level or at a salesman and branch level. If the former, then you simply could not load the branch code into the customer table. If its the latter, you could create your own handling of the composite key, or you could leave the synthetic key in place.

The same analysis should be performed on the other synthetic key.

Building in your own handling of the composite key is unlikely to perform better in reload or in the front end.

Re: How to Remove the Synthetic Keys

Anonymous — Mon, 12 Dec 2016 05:14:19 GMT

Hi,

monthly sales activity table and

items master table you have filed like itmes#,

if you have same underlined data in that filed in both the tables,

create a..composite key with vndr# and items#,

or if you don't have same underlined data in items# in both the tables rename that in one table.

and

to avoid second synthetic key,

create composite key with branch_cd and cus_salesmen.

Re: How to Remove the Synthetic Keys

Mon, 12 Dec 2016 06:09:22 GMT

Simple task

Rename the fields as different which are not useful to link and make the fields same in the tables which are need to be link

Re: How to Remove the Synthetic Keys

asb02512 — Mon, 12 Dec 2016 07:30:52 GMT

thanks a lot shraddha

Re: How to Remove the Synthetic Keys

asb02512 — Mon, 12 Dec 2016 07:32:06 GMT

Thanks everyone. Issue resolved By Creating Composite Keys