check for data completeness oracle etl

I am new to oracle and I would like to know how do we check for complete data load and validate boundary values as part of the ETL testing process. (The two tables could be T1 and T2). Please let me know a sample query.

Thanks, Santosh