jeudi 15 février 2018

How to validate nulls - oracle etl testing?

I am new to oracle and I would like to know how do we check the nulls in non null columns in oracle tables as part of the ETL testing process. (The two tables could be T1 and T2). Please let me know a sample query.

I have already tried

select count(*) from T2 where T2.column = Null;

Thanks, Santosh

Aucun commentaire:

Enregistrer un commentaire