Help Center/ Data Warehouse Service/ Best Practices/ Data Migration/ Using CDM to Migrate Oracle Data to a DWS Cluster/ Migrating Full Table Data/ Verification
Updated on 2025-09-18 GMT+08:00
View PDF

Verification

  1. In the test database of DWS, run the following SQL statement to query the number of rows in the table apex2_dynamic_add_remain_test. If the number of rows is the same as that in the source table, the data is consistent. 

    1
    		 
    SELECT COUNT(*) FROM  db_user01.apex2_dynamic_add_remain_test;

  2. Run the following statement to check the data skewness:

    If the data skewness is within 10%, the data distribution is normal. The data migration is complete. 
    1
    		 
    SELECT TABLE_SKEWNESS('db_user01.apex2_dynamic_add_remain_test');