In this video I have shared 5 simple examples to showcase how soft rules can be implemented in the Staging AREA in the ETL pipeline.
You can work with DATE & STRING columns and implement rules like max length, standardizing date format , generalizing different string values.
If you are learning SQL I also have a free training to give you alternate approach to learn SQL query solving. I promise you this is not typical SQL tutorial course.
Try the free training if you wish to learn SQL:
https://etlsql.kartra.com/page/sps-fr...
*The course is not SQL from scratch. It requires that you already know SQL basics.
If you need any help related with SQL , you can reach me out at : [email protected]
If you like this video and my work, please drop a comment to share some love.
Cheers,
Nitin