AnsweredAssumed Answered

Data Validation and Deletion of Data

Question asked by ranjith.martha569090 on Oct 25, 2017
Latest reply on Oct 27, 2017 by Srinivas Chandrakanth Vangari

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.

Outcomes