SAP Knowledge Base Article - Public

3573719 - Information message shown in the Monitor "The data will be reflected in Local Table (File) target table only after the merge job is completed."

Symptom

  • Object store space with storage type SAP HANA Data Lake Files has been enabled in Datasphere tenant.
  • While replicating data to HANA Data lake file, replication flow initial load is completed but information message shows in the Data Integration Monitor "The data will be reflected in Local Table (File) target table only after the merge job is completed." 
  • No data is fetched when previewing data in target local table (File).

Environment

SAP Datasphere

Reproducing the Issue

  • Data preview in Data builder for local table file
  • No data shown in output

Resolution

  • We recommend to create a merge job for the target local table (file). The merge job is required to write the data from the staging area (data is stored in files) to the delta tables in the object store. Otherwise data would not be visible when previewing / using the local table file. 
  • Create a task chain for the replication flow and Local Table (File) by referring to the documentation Creating a Task Chain | SAP Help Portal . 

    See Also

    Acquiring and Preparing Data in the Object Store

    Keywords

     merge job, local table file, no data, "The data will be reflected in Local Table (File) target table only after the merge job is completed", replication flow, merge, object store , KBA , DS-DI-SCH , Scheduling and Task Chains , DS-DI-RF , Replication Flows , Problem

    Product

    SAP Datasphere all versions