public StringBuilder TheJoin(Datamart datamart, Group group, int nr)
{
StringBuilder query = new StringBuilder();
query.AppendFormat(" LEFT JOIN {0}.{1} AS G{2} ON G{2}.id = F.{3}", datamart.DatamartName, group.GroupName, nr, group.FactKey);
return(query);
}
public StringBuilder TheFrom(Datamart datamart)
{
StringBuilder query = new StringBuilder();
query.AppendFormat("FROM {0}.{1} AS F", datamart.DatamartName, datamart.FactName);
return(query);
}
