Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Child table not populating due to referential integrity constraint

  1. #1

    Default Child table not populating due to referential integrity constraint

    Hello,
    I have department table with deptId as the primary key and an Employee table with deptId as the foreign key. When I use table outputs for employee and department, it gives me an error for employee table saying parent key not found. How can I ensure that the employee table gets populated only after the department records are completely put into the department table?
    I don't plan to remove the referential integrity constraints.

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    If you don't want to disable foreign key checks temporarily, usage of Block-this-step-until-steps-finish can ensure departments are inserted before depending employees.
    I would prefer to handle departments and employees in different transformations, though.
    So long, and thanks for all the fish.

  3. #3

    Default

    Great! The 'block-this step' worked for me. Thank you very much!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.