Create Muliple Jobs in Data Sync

Question

Summary

Content

Hi,

Can we able to create multiple jobs in Data Sync as below

Job 1 -- Will move data from Source System to Cloud Stage Schema

Job 2 -- Cloud Stage Schema to Final Cloud Schema (DW Schema)

I created Connection As below

And Created 2 Jobs:

In Job1 - Mentioned Source as "Src" and Target as "Cloud_dw_stg"

In Job2 - Mentioned Source as "Cloud_dw_stg" and Target as "Cloud_dw"

I created these jobs and update jobs, but when i executed all tasks are present in both Jobs.

Can we segregate Task based on our Source-Target Connection details.

I am using Data Sync Version : Oracle Business Intelligence Cloud Service Data Sync (2.3)

User743400-Oracle · Answer

thats the best way to organize. You can also chain the jobs to run one after the other. Refer at on-demand-etl.xml file where you can trigger a job based on a file signal. At the end of every job, in the log\jobsignal directory, you will find _StartSignal.txt, _CompletedSignal.txt, or _FailedSignal.txt. Using these files, you can configure it to run Job1, look for Job1_CompletedSignal.txt to start Job2.

Samarendra Ora · Answer

I did a work around,

I created 2 Projects and 1 job in each project

Poject1--Source-to-Stage-Extract : Job - Mentioned Source as "Src" and Target as "Cloud_dw"

Project2--Stage-to-Target-Extrcat : Job - Mentioned Source as "Cloud_dw" and Target as "Cloud_dw"