Tuesday, April 28, 2015

0 Workflows in Informatica





A workflow defines the logical order of execution of tasks such

as sessions. While a session itself is linked to a mapping and hence

indirectly defines the data flow between a source and target, most data

integration applications are usually more complex than interacting with a

single source/target. When there are multiple sessions involved, there usually

is an order in which they need to be executed. For example, before loading transactions data, one has to ensure that the customers' and products' data for

the corresponding transactions is up-to-date. This ensures the data integrity and

avoids any key violations. Hence, a workflow is created where the order in

which the sessions need to be executed can be defined. Sessions can be

configured to run in sequence or in parallel or a combination of both.


No comments:

Post a Comment