Identifier
In addition to the customized columns selected to be compared, the tool will automatically include in the results a set of Identifier columns that may be needed to identify each row. A built-in heuristic will select these columns for each table. The heuristic rules are as follows:
-
Include these columns whenever present in both databases:
|
Year Hydro Year Demand Year Number |
Area Number Type Percentile |
Capacity Price Area Demand Hour Demand Month |
-
Include any column that ends in one of the following suffixes:
ID
Name
Unless it is more than 2 words long or if it starts with “zREM” (case insensitive)
Productivity Tools
Identifier
