# How do I confirm that validation was successful?

1. In SQL*Plus, using the destination account, run the following command to view the ETL_STATUS table:

   select step_name, to_char(start_date, 'HH24:MI:SS') start_tm, to_char(end_date, 'HH24:MI:SS') end_tm, pct_complete pct, next_person_id nxt_id, status from <dest_account>.etl_status order by start_date;

2. Make sure that:
   - The STEP_NAME column contains a Validate step.
   - The step has a STATUS of Completed.
   - A value exists in the END_TM column for the step.

   If the Validate step is missing or has a STATUS of Failed, validation was not successful.

Copyright © 2015 Oracle and/or its affiliates. All rights reserved.