Question Re: Replicate same source object with different target na... in Technology Q&A

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

SouravGupta — Wed, 22 Jan 2025 13:39:09 GMT

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.

Re: Replicate same source object with different target na...

murllimaraati — Wed, 22 Jan 2025 15:28:50 GMT

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

Re: Replicate same source object with different target na...

SouravGupta — Wed, 22 Jan 2025 17:49:41 GMT

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?

Re: Replicate same source object with different target na...

murllimaraati — Thu, 23 Jan 2025 10:22:18 GMT

You can have multiple replication flows and acheive it in multiple files.

Re: Replicate same source object with different target na...

SouravGupta — Thu, 23 Jan 2025 20:01:49 GMT

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.