tdspora / syngen

Open-source version of the TDspora synthetic data generation algorithm.
https://tdspora.ai/
GNU General Public License v3.0
17 stars 4 forks source link

Orphan Keys in Secondary Table Linked by Foreign Key #260

Open JeremyKulcsarDS opened 10 months ago

JeremyKulcsarDS commented 10 months ago

I am experiencing an issue while generating two tables linked by a foreign key from an original dataset. The problem arises when the synthetic data generation process produces children keys in the secondary table that cannot be traced back to any parent keys in the first table. This inconsistency is causing difficulties in maintaining the integrity of the linked data.

I would greatly appreciate any insights, suggestions, or potential solutions to address this issue.

Thanks.

Anna050689 commented 10 months ago

Thank you for your ticket. We will check it on our side and return back with the answer as soon as possible.

tdspora commented 6 months ago

@JeremyKulcsarDS Hello, Thank you for the issue once again. The case was checked against the latest versions of syngen and look like it is not reproduced. Please try the syngen of version 0.5.7 for your scenario.

Would be great to hear your feedback.

Regards, Olga