Enforce referential integrity with Transformation

More
2 months 6 hours ago #22771 by hanisultan
So I have a set of data that I need to insert into 2 tables, lets say user and employee - I need to insert into employee first to get an employee id then use that employee id to insert the user.  the dataset does have a unique identifier which I will be using to join with the employee after I do the insertion and obtain the employee id.  I can do this in 2 transformation but was wondering if there is a way to make it in one.  Something this    
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

More
2 months 5 hours ago #22772 by admin
This can be easily achieved by using a Data buffer transformation object

wiki.etl-tools.com/advanced-etl-processo...ng-data/data-buffer/

Mike
ETL Architect

Please Log in or Create an account to join the conversation.