I want to design an ETL job with combination of full load and delta logic. If I select Full load when execute it should run for full load and same for delta.
If data is wrong or not meet the validation transform then it should load to error table.
Once fix the data in source then the job should be run for those records which are loaded to error table.
Please advise how to achieve this.