I want to create a BODS job which redirects the output to two target tables of different databases say table 1 belong to oracle and table 2 belongs to HANA. with condition table 1 is loaded after every 1 hour and table 2 is loaded after every 12 hour.
As the DS unit of execution is the job level, you'll need to include the data flows in separate jobs and schedule them, one to run every hour, the other every 12 hours.
Add comment