Data Warehouse BI Question:

Orchestration:

The control over the web services that are involved and coordinating the execution of different operations on the web services involved in the operation is taken by the central process in orchestration as per the requirements. The involved web services are unaware of this process. With operations that are explicitly defined and the order of invocation of the web services, the orchestration is centralized.

Choreography:

Choreography does not rely on a central coordinator. The web services involved in the choreography is aware exactly the execution of its operations and whom to interact with. Choreography is a collaborative effort. It focuses on messages exchange. The awareness of business process, operations to execute, messages to exchange, and the time of message exchange are needed for all participants of choreography.