Main Content
Uncover relationships across tables or databases.
Relationship matching and discovery tools from DataFlux provide you with information about logistical pieces of data. Organizations maintain an enormous amount of data, such as customer data, supplier data, product data, operational and business intelligence data, financial and compliance data, and industry-specific data. Often, the data for any one of the data categories is spread across many data sources. DataFlux helps you understand and manage all of this data, as well as the sources and relationships of data across different applications.
"Related" records can be multiple records in the same data file, records across data files or records across databases. With relationship discovery, DataFlux solutions help you profile your data to answer the following questions:
- Are there potential key relationships across tables?
- If there is a primary/foreign key relationship, is it enforced?
- If there is an explicit or inferred key relationship, is there any orphaned data (data that does not have a primary key associated with it)?
- Are there duplicate records?
The figure below shows the results of a primary key/secondary key analysis, where two products listed in the sales data did not exist in the products table. Understanding relationships across data elements is the first step in consolidating, merging or matching information to get a single, best record of data.
