You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-07-28 11:38:49

shri411
Member
9 posts

shri411 said:

Talend MDM Primary Key configurations

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.
mini_blob_20160728-0418.png

Last edited by shri411 (2016-07-28 12:19:04)

Offline

#2 2016-07-28 15:46:46

asebastianelli
Member
132 posts

asebastianelli said:

Re: Talend MDM Primary Key configurations

do you need the SrcSysId  to filter the dropdown SorceDescription?

Offline

#3 2016-07-28 15:51:14

shri411
Member
9 posts

shri411 said:

Re: Talend MDM Primary Key configurations

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.

Offline

#4 2016-07-29 09:57:28

asebastianelli
Member
132 posts

asebastianelli said:

Re: Talend MDM Primary Key configurations

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

Offline

#5 2016-07-29 11:32:58

shri411
Member
9 posts

shri411 said:

Re: Talend MDM Primary Key configurations

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??

Offline

#6 2016-08-09 14:06:24

shri411
Member
9 posts

shri411 said:

Re: Talend MDM Primary Key configurations

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

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy