Pros
• Can be developed with special rules for data validation
• Transforms data from neutral (customer-supplied) to load-ready format
• Allows data segregation
• Consistent and explainable outcomes, unlike manual manipulation involved with the use of a tool such as Excel where there is the potential for error
• Transportable and shareable
• Runs on multiple operating systems