Friday, September 06, 2013

Difference between Control flow and Data flow

Difference between control flow and data flow:
  • Control flow is for designing the flow of package. Dataflow if for ETL process.
  • Dataflow is the subset of control flow.
  • There will be only one control flow while multiple dataflow can exists.
  • Data flow can’t work without a control flow.
Control flow is the main window or interface of the package where we design entire flow i.e. Control Flow depicts the flow of execution of task.
All the tasks in any packages are subset of control flow. So all this indicates that a package can have only one control flow. All process base tasks are part of control flow while ETL related tasks are the part of Dataflow which is again a subset of control flow.

No comments:

Post a Comment