CREATE TABLE employed( empid NUMBER, empname VARCHAR2(10), dept VARCHAR2(10), salary NUMBER ); CREATE TABLE sal_log ( log_id NUMBER GENERATED ALWAYS AS IDENTITY, empid NUMBER, empname VARCHAR2(10), ...
Validation of data before analysis. Manual validation of data quality and data cleaning. Auto validation by creating PL-SQL triggers. Following is a snapshot of the relational data ingested to a ...