Is there any way where we can extract the record counts of a table/tables from source and target , columns matching of the source tables and target tables and the values in each column between source and target. All these can be extracted from replicate? Any tables that capture these information? my source is SAPHANA and targets are Azure managed instance and Azure synapse
We don't have any data profiling and data validation tools to Replicate. I would suggest you open an enhancement feature request in the Community Ideas board, following this link.
Thank you for the post to the QDI forums. With Replicate there is no validation tool for comparing the Source and Target data as this would be done outside of the Product once the data is loaded and Replicated to the Target using a ODBC/JDBC connection to the Target. Also with the Enterprise Manager you can get other statistics about the Tasks running in Replicate. Here is the link to QEM for more information as needed.
We don't have any data profiling and data validation tools to Replicate. I would suggest you open an enhancement feature request in the Community Ideas board, following this link.
that's ok . sorry for asking one more question ..... do we have any statistics data or any system tables for replicate where the information on schema level (for tables src to target) is being stored.
Thank you for the post to the QDI forums. With Replicate there is no validation tool for comparing the Source and Target data as this would be done outside of the Product once the data is loaded and Replicated to the Target using a ODBC/JDBC connection to the Target. Also with the Enterprise Manager you can get other statistics about the Tasks running in Replicate. Here is the link to QEM for more information as needed.
.png "Former Employee"){kind=icon}
