Frequently asked questions about analyzing across tables
Find answers to frequently asked questions about analyzing across tables, such as how the system differentiates between compatible pairs and incompatible pairs and whether column analysis is a prerequisite for foreign key analysis.
How does the system differentiate between compatible pairs and incompatible pairs?
To run a cross-domain analysis job, do any or all of the selected tables need to have a primary key?
How does the system differentiate between compatible pairs and incompatible pairs?
If the data type, length, and other properties of two columns in a pair are the same, the system concludes that the pair is compatible.
If I do not perform a base profile on some of the columns in a table, can those columns be analyzed in a foreign key analysis job containing that table?
No. Only columns that have been profiled in a column analysis job can be used in a foreign key analysis job.
Is it possible to select which pairs are used in a foreign key analysis job or a cross-domain analysis job?
No, all the possible pairs in the object list will be analyzed.
In the View Cross-Domain Analysis pane, where does the value in the Flag Percentage Above field come from?
The value is set in the project-level analysis settings. To modify this value in the console, select . The project-level settings are used for this field.
If I enter a new value in the Flag Percentage Above field, will the value be saved and displayed when I open the pane again?
No. You must change the setting in the Project Properties pane for it to persist. Clicking Apply only updates the object list.
In the Cross-Domain Analysis pane, what do the different bars in the Column Analysis column represent?
- An empty bar means that column analysis has not been performed on any of the columns in the table.
- A solid bar means that column analysis has been performed on all of the columns in the table.
- A half-filled bar means that column analysis has been performed on some of the columns in the table.
To run a cross-domain analysis job, do any or all of the selected tables need to have a primary key?
No, the only prerequisite is that you ran a column analysis job on the selected columns in the tables.
What do the flags indicate on the cross-domain analysis detail pane? What if some rows do not contain a flag?
A flag indicates that a value is unique. The value is either present in the base column or in the paired column. A row without a flag means that the particular value can be found in both columns.