private static string GetOnClauseOnValue(string depentdentTable , string prefix , FactDimensions fact)
{
return ConfigSettings.On + depentdentTable + "." + prefix + ConfigSettings.WhatKey + " = " + fact.Whatkey +
ConfigSettings.And + depentdentTable + "." + prefix + ConfigSettings.How3Key + " = " + fact.Howkey +
ConfigSettings.And + depentdentTable + "." + ConfigSettings.When3Key + " = " + fact.Whenkey +
ConfigSettings.And + depentdentTable + "." + prefix + ConfigSettings.Where4Key + " = " + fact.Wherekey;
}
public static string GetChildIdQuery(FactDimensions factDimension)
{
return GetSelectDistinctClause(ConfigSettings.Fact + "." + ConfigSettings.Id) +
GetFromClause(ConfigSettings.FactDataTable)+ConfigSettings.Fact+
GetJoinClause(ConfigSettings.ParentChildTable)+ConfigSettings.Child+
GetOnClauseOnValue(ConfigSettings.Child , ConfigSettings.Anchor , factDimension)+
GetConditionForStar(ConfigSettings.Fact , ConfigSettings.Child , ConfigSettings.Child);
}
