In previous posts I talked about DWLOADER and the distribution & replication theory, today I’m going to explain how you can combine this knowledge to achieve the ultimate PDW load speed with DWLoader. There are 3 things that determine your load speed File size Destination Table Design Structure of the file I will start…
Today I want to talk a bit more about Distribution and Replication and how it is used in a PDW. I’m going to start by answering two questions. What is Distribution? Because MS PDW is a MPP system (http://swyssql.wordpress.com/2013/12/13/basic-introduction-to-ms-pdw/), it uses different nodes to ensure fast querying! With the Distribution theory we take our large…
Today I will enlighten you about the incredible fast load times which you will get with a Microsoft Parallel Data Warehouse! The first thing you have to do when you work with a MSPDW is load your data into the PDW. This initial load will be the most “time consuming” so with this post I…
