I have 3 Target tables and during load for each table we need to do few validations.
Source is a Excel with 3 Tab.
Table1 - CUST
Table2 - PRO
Table3 - DEPT
If the Data validations are met and loaded in 1st Table - CUST.
1. During the loading of PRO for any reason data is not validated and want to fail the process.
2. Also delete the Data loaded in CUST Table.
How can we achieve this.
Same applies to DEPT, if during data validation of DEPT Source Data, if it fails - delete the data from CUST and PRO
Looks like we can create Temporary Tables (STAGE) or use the Document cache.
Is there any other better approaches and how can we achive this.
Can you provide sample process flow.