public String generateQuery(TableNode node) {
    StringBuffer select = new StringBuffer("SELECT");

    select.append(token);
    // generate select clause

    select.append(getSelectClause(node.getName()));
    select.append(token);
    return select.append("FROM ").append(node.getName()).toString();
  }
 public void addAssociation(TableAssociation ass) {
   String indexKey = null;
   TableNode src = ass.getSource();
   TableNode target = ass.getTarget();
   String index1 = src.getName().split("_")[0];
   String index2 = target.getName().split("_")[0];
   if (index1.equals(index2)) {
     indexKey = index1;
     if (index1.length() > 12) indexKey = index1.substring(0, 11);
   } else {
     indexKey = "MIXED";
   }
   kettleDao.addAssociation(ass, indexKey);
 }