/** * 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); }