How do we refine and load data into a relational database in Diyotta?
To refine or filter the data from any source system and load into a relational database, we have transformation in Diyotta which is called “Filter”. Filter transformation will be shown under Transforms tab on the Left panel of the screen.
We can choose the source and target to which we must load filtered data and data flow should be created with them. Place a filter transform between source and target and give the valid condition which fetches the required data.
Based on the condition given, records will be filtered and loaded into target.