Redundancy Analysis - Comparing tables from different schemas
Hello, I want to use the redundancy analysis feature of TOP to compare foreign keys to primary keys. However the Oracle database I am analysing has the tables to be compared under different schemas. I found that redundancy analysis only works for tables within the same Oracle schema. Can you please confirm that this is indeed the case and whether there are any plans to extend TOP to support table comparison across different schemas. Appreciate your help. Regards, George
Hi George,
indeed the redundancy analysis only works for tables in a same schema. The reason is that SQL is generated to compute the indicators.
I'm not sure right now, but you may be able to create a synonym table or view on the table which belongs to the other schema. This could help you to do the profiling.
If that's not possible, then please open a feature request in our bugtracker. We are in the process of defining the roadmap for the next release. Maybe this feature would be part of it.
Thanks for confirming that Sebastiao. Yes, I think it makes sense to allow comparing tables across schemas in Oracle. For example, I am dealing now with a data warehouse that has fact tables in one schema and dimension tables in a different schema, so I am writing SQL to check referential integrity. Cheers, George
Sebastiao,
Can you please update us whether the ability to compare columns present in different schemas has been included in the later releases of TDQ? (I am currently using version 4.0.3).
Our analysis is hugely dependent on this feature on a very high priority and it would be of great help to us if this feature has been enabled now.
Thanks!
Mythili
Hi,
I am running into the same issue. That functionality will definately take this software to the next level. Please let me know when/if you create an update to the software.
Thank you
