Convenience and power like that make data warehouse creation a well-synchronized effort, rather than a resource drain. You can display descriptive metadata like table and column descriptions to help make sense of column names. While there's no need to know SQL, advanced users can edit the query or write their own. Large relational databases can be efficiently loaded with automated bulk load procedures. There are two bulk data movement modes.
Administrative functions are simple.
And concurrent connections to multiple servers facilitate moving copy requests from one server to another. Copy Manager provides full auditability of the ETL process. Each process generates a complete record of results, including a log of significant events that occurred during its run.