How do we split data into two or more different relational database tables in Diyotta?

How do we split data into two or more different relational database tables in Diyotta?

Beginner Asked on July 16, 2019 in Diyotta Studio.
Add Comment
1 Answer(s)

To split data from a source into two or more different target tables, we have a transformation in Diyotta which is called “Splitter”. Splitter transform splits the source data based on the condition provided and loads to the target as per the mapping done. Splitter transformation will be shown under Transforms tab on the Left panel of the screen.

RE: How do we split data into two or more different relational database tables in Diyotta?

We can choose a source and two or more targets to which we would like to load, and data flow should be created with them. Place a Splitter transform between source and targets and give the valid condition which fetches the required data.

RE: How do we split data into two or more different relational database tables in Diyotta?

Based on the condition given, records will be splitted and loaded into respective targets.

Expert Answered on July 16, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.