For your larger tables, you may instead want to consider Integration Services. Integration Services offers greater functionality and arguably more end-to-end convenience. This is because Integration Services is able to connect directly to the data source and load the data into the PDW appliance without having to stop at a file share. Another important distinction is that Integration Services can also perform transformations in flight, which DWLoader does not support.
- Chapter 8: Loading a PDW Region in APS
- from SQL Server Integration Services Design Patterns, Second Edition
- Publisher: Apress
- Released: December 2014
Best approach utilizes both DWLoader and Integration Services
Share this highlighthttp://www.safaribooksonline.com/a/sql-server-integration/75335/