private function cacheDistinctValues()
{
$queryToCleanCach = $this->prepareQueryToCleanCacheDistinctValues();
$queryToCach = $this->prepareQueryToCacheDistinctValues();
$dbHandler = DatabaseHandlerFactory::createDatabaseHandler("mssql", MSSQL_CQS_DB_USER, MSSQL_CQS_DB_PASSWORD, MSSQL_RC_DB_DATABASE, MSSQL_CQS_DB_HOST, MSSQL_CQS_DB_PORT, null, null);
//var_dump($queryToCleanCach, $queryToCach, $dbHandler);
$dataMatchingCheckerDAO = new DataMatchingCheckerDAO();
try {
$dataMatchingCheckerDAO->setQueryRelationshipColumnCaching($this->source->transformation, $queryToCleanCach);
$dbHandler->ExecuteNonQuery($queryToCleanCach);
$dataMatchingCheckerDAO->setQueryRelationshipColumnCaching($this->source->transformation, $queryToCach);
$dbHandler->ExecuteNonQuery($queryToCach);
$dataMatchingCheckerDAO->setSuccessRelationshipColumnCaching($this->source->transformation);
} catch (Exception $e) {
$dataMatchingCheckerDAO->setFailureRelationshipColumnCaching($this->source->transformation, $e->getMessage());
}
}
