ETL process with drag and drop functionality
Enhancing the ETL process with drag and drop feature can help to easily perceive how the tables are being converted in each stage.
- Each logic is the box can be dragged and dropped on a layout. Boxes are the processes
- Left-hand node is for input and right is for output
- Hover or double click on the input node to see the actual table and do the same on the right node to see the table after the logic has been applied
- Double-clicking on each stage will open up a parameter window where we can apply the desired process or logic
- Giving a different color to each stage of ETL
I hope this would help to understand and haste the ETL process more efficient.