Regarding Change Tracker Query/Results

30 Views

Hi All

Can you please tell me what does this query do and also what parameters to be replaced with the original query. Please revert ASAP. We need to configure the Change Tracker and we are not aware of the actual process of doing that while we are having the standard SAP documentation for the same.

Procedure of locating the MDM Change Tracking Connection Parameter:

1. Located on the same DBMS Server as the MDM repository

2. The name of the main Connection Parameter is <name>_m000 and the name of the corresponding Change Tracking Connection Parameter is <name>_z000

3. The following statement can assist in finding the Change Tracking Connection Parameter:

*SELECT CATALOG_TAG Repository, MAINDB Main DB,replace(replace(MAINDB,'_M','_z'),'_m','_z') Change Tracking DB FROM A2I_XCAT_DBS.A2I_CATALOGS*

4. Find table with the name A2i_CM_History

...................................................................... and so on