cancel
Showing results for 
Search instead for 
Did you mean: 

Replicate same source object with different target name within the same space in Datasphere

SouravGupta
Discoverer
217

Hello,

I have a source CDS view within my S4HANA on Prem system (I_GLACCOUNTLINEITEMRAWDATA) with data from 2021 onwards. The amount of data in the table is huge. I want to replicate the view into Google Cloud Storage files and then load the files into Google Big Query. Since the volume is huge, I want to split the replication flows into smaller flows by giving the FiscalYear filter. I created a replication flow (Job_2021), gave I_GLACCOUNTLINEITEMRAWDATA as source, created a filter on FiscalYear 2021 and renamed the default target object, I_GLACCOUNTLINEITEMRAWDATA to I_GLACCOUNTLINEITEMRAWDATA_2021. I saved the job and deployed. It went through successfully. After that, I wanted to create the next job, Job_2022 with same source, filter as 2022 and renamed the target object within the flow as I_GLACCOUNTLINEITEMRAWDATA_2022. When I am trying to deploy it, I am getting an error saying that the object I_GLACCOUNTLINEITEMRAWDATA exists in another space. Is there a solution to this? I simply want to split the source data into multiple tables/files in target.

View Entire Topic
murllimaraati
Participant
0 Kudos

If the volume is huge you can use partition in replication flow and load the data in a single target file.

SouravGupta
Discoverer
0 Kudos
I am currently using multiple threads while doing the replication of initial data. However, my requirement is to split the data into multiple target files based on the FiscalYear field. Is there a better way to accomplish this?
murllimaraati
Participant
0 Kudos
You can have multiple replication flows and acheive it in multiple files.
SouravGupta
Discoverer
0 Kudos
Hi Murali.. That is exactly what I tried to do. I tried to create multiple replication flows and have multiple target files but got the error as mentioned in my ticket. It is not allowing me to deploy multiple replication flows having same source objects. I am even trying to rename the target object to different names but getting the same error.