Default value for Foreign key field

djugal — Sat, 16 Nov 2024 05:07:05 GMT

Hi,

I have a data model of two entities

Student(ID, Name, CountryID) Countries(ID, Name)

Now I have a data for Countries entity which is 0 - No Country Selected

How do I apply the same to my data model for the column Student / CountryID

I have tried with default value rule as [0] but still comes empty. Cant specify string here as "No Country Selected"

Re: Default value for Foreign key field

Anonymous — Mon, 19 Aug 2019 03:55:15 GMT

Hello @djugal，

Are you trying to validate patterns? Could you please give us more detailed steps to reproduce your issue? On which talend MDM build version you got that?

Best regards

Sabrina

topic Re: Default value for Foreign key field in Talend Data Catalog

Default value for Foreign key field

Re: Default value for Foreign key field