topic Re: Talend MDM Primary Key configurations in Talend Data Catalog

Talend MDM Primary Key configurations

Anonymous — Thu, 28 Jul 2016 11:38:49 GMT

Hi Everyone. I have a requirement to have a combination of two fields as a primary key and that was achieved by selecting the "add key fields" option from the entity.
The other requirement is I need to set up the same key as foreign key to another field in another table.
Is it possible??
In the Screenshot attached I need the SrcSysId field also to be a foreign key to another table so that I can use the drop down options of the foreign key to select the values.
Please Respond if anyone has idea on this.

Re: Talend MDM Primary Key configurations

Anonymous — Thu, 28 Jul 2016 15:46:46 GMT

do you need the SrcSysId to filter the dropdown SorceDescription?

Re: Talend MDM Primary Key configurations

Anonymous — Thu, 28 Jul 2016 15:51:14 GMT

Yes.The requirement is to have a single field as both UK and foreign key(SrcSysId), And It should have the option to select from the drop down like how a foreign key has.

Re: Talend MDM Primary Key configurations

Anonymous — Fri, 29 Jul 2016 09:57:28 GMT

I dont think you really need a composite key.. have you looked at the foreign key filter?
this will translated in something like select SorceDescription from table where SrcSysId=yourfield

Re: Talend MDM Primary Key configurations

Anonymous — Fri, 29 Jul 2016 11:32:58 GMT

Correct.For population of SourceDescription ,I have done that ..But the requirement is to have a composite key with SrcSysId as one of the fields with another field and that SrcSysId must show all the values in drop down like how a foreign key shows.In other words ,It has to be set as both primary key and foreign key.Am I clear with my question??

Re: Talend MDM Primary Key configurations

Anonymous — Tue, 09 Aug 2016 14:06:24 GMT

Hi ,Any Update on this??? Can we have a same field as both primary key and foreign key??