生成QVD文件

//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;

 

posted @ 2016-03-01 12:24  我的小老虎  阅读(479)  评论(0编辑  收藏  举报