Multiple Stored Procedures are executed run during the Data Load in Strategy Enterprise Manager Dataload 10.x.
SP_EM_IS_LAST_UPD
SP_IS_CLEAN_FACT_CTW
SP_IS_SESSION
SP_EM_MACHINES
SP_IS_DOC_FACT
SP_IS_REP_FACT
SP_EM_DB_USER
SP_IS_PROJECT_FACT_1
SP_CT_REMOVE_DUPLICATES
The procedure called SP_IS_SESSION includes the SQL that meant to run during the Enterprise Manager Dataload process exist on the table EM_SQL in Strategy 9.x.
In the MAEntMgr.xml file, it is noticed the procedures are executed one by one after “Starting Fact Migration.”
<log4j:event logger="MAEntMgr" timestamp="1494798582612" level="INFO" thread="pool-2-thread-2"> <log4j:message type ="DEFAULT"><![CDATA[Starting Fact Migration]]></log4j:message> </log4j:event> <log4j:event logger="MAEntMgr" timestamp="1494798582617" level="INFO" thread="pool-2-thread-2"> <log4j:message type ="DEFAULT"><![CDATA[Executing SP_EM_IS_LAST_UPD]]></log4j:message> </log4j:event> <log4j:event logger="MAEntMgr" timestamp="1494798582873" level="INFO" thread="pool-2-thread-2"> <log4j:message type ="DEFAULT"><![CDATA[Executing SP_IS_CLEAN_FACT_CTW]]></log4j:message> </log4j:event> <log4j:event logger="MAEntMgr" timestamp="1494798596001" level="INFO" thread="pool-2-thread-2"> <log4j:message type ="DEFAULT"><![CDATA[Executing SP_IS_SESSION]]></log4j:message> </log4j:event> <log4j:event logger="MAEntMgr" timestamp="1494798635669" level="INFO" thread="pool-2-thread-2"> <log4j:message type ="DEFAULT"><![CDATA[Executing SP_EM_MACHINES]]></log4j:message> </log4j:event> <log4j:event logger="MAEntMgr" timestamp="1494798642583" level="INFO" thread="pool-2-thread-2"> <log4j:message type ="DEFAULT"><![CDATA[Executing SP_IS_DOC_FACT]]></log4j:message> </log4j:event> <log4j:event logger="MAEntMgr" timestamp="1494798642834" level="INFO" thread="pool-2-thread-2"> <log4j:message type ="DEFAULT"><![CDATA[Executing SP_IS_REP_FACT]]></log4j:message> </log4j:event> <log4j:event logger="MAEntMgr" timestamp="1494798755248" level="INFO" thread="pool-2-thread-2"> <log4j:message type ="DEFAULT"><![CDATA[Executing SP_EM_DB_USER]]></log4j:message> </log4j:event> <log4j:event logger="MAEntMgr" timestamp="1494798766303" level="INFO" thread="pool-2-thread-2"> <log4j:message type ="DEFAULT"><![CDATA[Executing SP_IS_PROJECT_FACT_1]]></log4j:message> </log4j:event> <log4j:event logger="MAEntMgr" timestamp="1494798793508" level="INFO" thread="pool-2-thread-2"> <log4j:message type ="DEFAULT"><![CDATA[Executing SP_CT_REMOVE_DUPLICATES]]></log4j:message> </log4j:event> <log4j:event logger="MAEntMgr" timestamp="1494798793639" level="INFO" thread="pool-2-thread-2"> <log4j:message type ="DEFAULT"><![CDATA[Finished Fact Migration]]></log4j:message>
