Scripts can be written that adapt "business rules", and can be initiated when the report is published. For example, notifications, alerts and messages can be delivered to distributed users with email to all the parties who are authorized to view the report. Notifications can also be sent using Instant Message platforms across the network notifying of report publishing and availability.
The DART data transformation process will apply a series of "rules" or functions to the extracted data from the source to derive the data to be loaded to the end target and technical specification of the end target may be required:
- Selecting only certain columns to load (or selecting null columns not to load)
- Translating coded values (e.g., if the source system stores 1 for male and 2 for female, but the destination stores M for male and F for female)
- Encoding free-form values (e.g., mapping "Male" and "1" and "Mr" into M)
- Deriving a new calculated value (e.g., sale_amount = qty * unit_price)
- Joining together data from multiple sources (e.g., lookup, merge, etc.)
- Summarizing multiple rows of data (e.g., total sales for each store, and for each region)
- Splitting a column into multiple columns (e.g., putting a comma-separated list specified as a string in one column as individual values in different columns)







Alphametrics.