AnsweredAssumed Answered

How to model 1 to many relationships

Question asked by timschmick on Mar 13, 2015
Latest reply on Oct 2, 2015 by dovle01

What is the preferred way to model a 1 to many relationship for creating synthetic data within Data Finder?  For example Person -> Address (a person can have multiple addresses, but doesn't have to have any).

 

My current approach is to use a randnull function on the key field for the 'many' side and add a post processing step to delete any values with a NULL key.  The performance implications aside, this also requires me to model the source/target in a separate staging schema that removes the foreign key constraints, which seems overly complex. 

Outcomes