Data Validation after migration from the Azure Data Factory

Hi,

I would be migrating 1.5 TB data from on-premises (Oracle) to the Azure SQL database using the Azure Data Factory (SHIR).

Question-1 -Please inform how to perform the data validation between oracle and azure Sql database.

Database Size- 1.5 TB

Source Database- Oracle (on-premises)

Target Database- Azure Sql Database (Public Cloud Access-Disable)

We won’t be able to enable the public cloud access to the azure sql database as per project architect and oracle database can only be connected through SHIR

Total Tables-229

Records Count – 100000+ in few large tables.

Please inform the validation method as i cannot use the Azure data flow, it does not connect to the on-premises database.

Question-2 In above I would be migrating the large amount of blob data from oracle to azure sql database?

How to validate the blob data type migration validation from oracle on premises to the azure sql database ?