Frequently asked questions about analyzing tables
Find the answers to frequently asked questions about analyzing tables, such as what the difference is between analysis statistics and full volume duplicate check data.
What is the difference between analysis statistics data and a full volume duplicate check of data?
Analysis statistics data is based on the analysis set that you selected. The data can be based on either a data sample or the full table. A full volume duplicate check is always based on the full table.
I clicked Remove All MCPK. Why did it not remove all of the records that are shown in the multi-column analysis results view?
Any combinations that are created outside of multi-column primary key analysis, such as a virtual column or a defined composite primary key, are not removed.
How does changing the column sequence in run duplicate analysis affect the duplicate check analysis results?
Changing the order of the columns in the column sequence object list has no effect on the duplicate check results.
I am exporting a reference table in the Table Management workspace. What is the fixed width file option?
When the reference table is exported, the width between two column values in the exported file is determined by the display length of the column. Because the width is already defined, it is called fixed width. You can view the reference table metadata by selecting the View Metadata task from the Tasks pane.