SQL: Difference between control flow and data flow

Control flow is where you define operations and order of execution of those operations. for example you put two operations: execute t-sql command on a database and send mail. then you define order of them with Precedence Constraint for example the t-sql statement should be executed and then if it succeeded mail will be send.

Data flow is where you define data stream; where data comes from (data sources), how data should be transformed (transformations) and where data should be loaded (data destinations). you can pass data from a component to another components with Data Paths.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s