Skip to main content

Setting up remaining object transformations in OCDM

  1. Access data integration and go to the OCDM pool related to the package.

  2. Access the Transformation from THActionBasedLog - 1

  3. Replace the Join mapping in line 4 as follows:

    Existing mapping: "${{JmTAcx_THWriteback}}"."OpportunityMapping"

    Replacement: <%=DATASOURCE:TH_WRITEBACK%>."OpportunityMapping"

  4. Similarly, replace the Join mapping in line 17 as follows:

    Existing mapping: "${{JmTAcx_THWriteback}}"."KPIMapping"

    Replacement: <%=DATASOURCE:TH_WRITEBACK%>."KPIMapping"

  5. Select the Data Source as KPI Logging - Combined Data Pool and Save with Validation.

  6. Access the Transformation from THRateBasedLog - 1

  7. Replace the Join mapping in lines 4 as follows:

    Existing mapping: "${{JmTAcx_THWriteback}}"."OpportunityMapping"

    Replacement: <%=DATASOURCE:TH_WRITEBACK%>."OpportunityMapping"

  8. Similarly, replace the Join mapping in line 13 as follows:

    Existing mapping: "${{JmTAcx_THWriteback}}"."KPIMapping"

    Replacement: <%=DATASOURCE:TH_WRITEBACK%>."KPIMapping"

  9. Select the Data Source as KPI Logging - Combined Data Pool and Save with Validation.

  10. Access the Transformation from THNonMonetaryLog - 1

  11. Replace the Join mapping in lines 4 as follows:

    Existing mapping: "${{JmTAcx_THWriteback}}"."OpportunityMapping"

    Replacement: <%=DATASOURCE:TH_WRITEBACK%>."OpportunityMapping"

  12. Similarly, replace the Join mapping in line 17 as follows:

    Existing mapping: "${{JmTAcx_THWriteback}}"."KPIMapping"

    Replacement: <%=DATASOURCE:TH_WRITEBACK%>."KPIMapping"

  13. Select the Data Source as KPI Logging - Combined Data Pool and Save with Validation.

  14. Access the Transformation for THOpportunities - 1

  15. Replace the Join mapping in line 8 as follows:

    Existing mapping: "${{JmTAcx_THWriteback}}"."OpportunityMapping"

    Replacement: <%=DATASOURCE:TH_WRITEBACK%>."OpportunityMapping"

  16. Select the Data Source as KPI Logging - Combined Data Pool and Save with Validation.

  17. Access the Transformation for THLogEntry - 1

  18. Select the Data Source as OCDM Schema and Save with Validation.

  19. Select the following data connections for the remaining objects.

  20. Once you have selected the right data connections, you should be able to view the KPI Logging Combined Data Pool as the data source for all the objects except THLogEntry, which should be blank.

    Screenshot_2026-03-27_at_13_51_35.png

  21. Ensure to enable all the transformations and create a version and deploy OCDM to development.

    Screenshot_2026-03-27_at_13_52_15.png

  22. Access the Data Jobs, and execute the data job (all transformations, full load).