- Posts: 725
- Thank you received: 15
Enforce referential integrity with Transformation
- hanisultan
-
Topic Author
- Offline
- Platinum Member
-
Less
More
2 months 6 hours ago #22771
by hanisultan
Enforce referential integrity with Transformation was created 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.
2 months 5 hours ago #22772
by admin
Mike
ETL Architect
Replied by admin on topic Enforce referential integrity with Transformation
This can be easily achieved by using a Data buffer transformation object
wiki.etl-tools.com/advanced-etl-processo...ng-data/data-buffer/
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.