I am new to DI, I am trying to understand the difference between batch jobs and real-time jobs. The help files do not help in this distinction. Any clarification would be very helpful.
thanks,
mverdera (BOB member since 2007-05-09)
A batch job is something that you start, it does the processing like reading tables and loading the data warehouse, and then it stops until it is started again, e.g. every night, twice a day, every 4 hours.
A realtime job is started once at the beginning and then runs for ever. Whenever a new message is sent, it will get processed and then the realtime job waits for the next message.
So one difference is that with batch jobs you have the entire overhead of starting, connecting to the databases and stopping the process - in realtime not.
And another difference is push vs. pull. A batch job pulls all records (“Select all rows with change_date > sysdate()-1”), a realtime somebody pushes a message into. So your source system has to have the capability to do so, like does Webservice calls, any Queueing software (MQ, Tibco, JMS,…)
Werner Daehn 
(BOB member since 2004-12-17)