//Loading the data from DB to local disk folder BI_CUSTOMER: LOAD CITY, "CUSTOMER_ID", "CUSTOMER_INDUSTRY", "CUSTOMER_NAME", "CUSTOMER_NUMBER", LOB, "OPERATION_UNIT", "ORGANIZATION_ID"; SQL SELECT CITY, "CUSTOMER_ID", "CUSTOMER_INDUSTRY", "CUSTOMER_NAME", "CUSTOMER_NUMBER", LOB, "OPERATION_UNIT", "ORGANIZATION_ID" FROM DW.dbo."BI_CUSTOMER"; STORE BI_CUSTOMER INTO D:\Qlikview_QVD_NEWDW\DW\BI_CUSTOMER.qvd (QVD); drop table BI_CUSTOMER;
原文:http://www.cnblogs.com/olapforever/p/5230512.html