How do we split data into two or more different relational database tables in Diyotta?
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.
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.
Based on the condition given, records will be splitted and loaded into respective targets.