/**
* Shows results of the normalization for selected attribute
*
* @param schema schema where result transformation view resides
* @param attribute name of the attribute which was normalized
* @param normalizeType type of normalization performed
* @param xformResult name of the result transformation view
*/
public static void displayNormalizeResults(
String schema, String attribute, OraNormalizeType normalizeType, String xformResult) {
System.out.println("\nShowing results of the normalization transformation");
System.out.println(
"\tNormalize type: "
+ (true == normalizeType.equals(OraNormalizeType.min_max) ? "min_max" : "z_score"));
System.out.println(
"\tMinimum and maximum values for:" + attribute + " before normalize transformation");
String sqlQuery =
MessageFormat.format(
"SELECT MIN ({0}) MIN_VALUE, MAX ({0}) MAX_VALUE FROM ({1})",
new String[] {"\"" + attribute + "\"", schema + "." + "MINING_DATA_BUILD_V"});
getMinMax(sqlQuery);
System.out.println(
"\tMinimum and maximum values for:" + attribute + " after normalize transformation");
sqlQuery =
MessageFormat.format(
"SELECT MIN ({0}) MIN_VALUE, MAX ({0}) MAX_VALUE FROM ({1})",
new String[] {"\"" + attribute + "\"", schema + "." + xformResult});
getMinMax(sqlQuery);
}
