Dell PowerEdge R510 - Manual (Page 17)

Dell R510 Reference Configuration for Microsoft SQL Server® 2008 R2 Fast Track Data Warehouse
Page 15
have the option of specifying whether they wish to attempt to auto-repair bad data, or simply reject
rows that are “dirty”. All validation results are routed through a “clean” or “rejected” path which
allows users to explicitly handle either scenario.
Message
user-defined dynamic notifications
For any step of the integration workflow, Message components can be used to create dynamic
notifications that make use of content from the actual data being integrated. This allows the creation
of messages like "Invoice 1234 was successfully processed for customer ABC Inc." Connectors are then
used to deliver the message to the appropriate end point.
Route
dynamic, content based routing
Route components examine any of the content in the actual data being processed, or use numerous
other properties available to the user (such as directory, file name, etc.) and route the extracted data
down specific paths of execution.
Split
intelligent data splitting and aggregation
Split components re-organize data into logical representations such as business transactions. For
example, you can take incoming invoice headers and details, and create logical invoice documents to
ensure the applications being integrated process or reject the entire invoice vs. discrete pieces.
Testing Integrations
real-time
To further simplify and shorten the integration development cycle, users can test their integrations
directly in the build environment. Integration testing includes watching as the data moves through the
integration process, viewing the actual data, monitoring exactly where the integration fails, and click-
thru on the failed step to examine error messages.