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
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
SAP Knowledge Base Article - Public