1.oracle數(shù)據(jù)庫中查字段名稱、類型及comment

select t1.column_id,t1.DATA_TYPE,t.column_name,t.comments from all_col_comments t,all_tab_columns t1 where t.owner = t1.owner  and t.table_name = t1.table_name and t.COLUMN_NAME = t1.COLUMN_NAME and t.table_name ='A_DC_FH_JG' order by t1.column_id

2.查詢owner

select owner,table_name from all_tables t where t.owner not like '%SYS%' and table_name='TT_BIL_MON_REBATE_DETAIL

3.數(shù)據(jù)導(dǎo)出將txt轉(zhuǎn)成csv

hive -e " select * from a where a.rn=1 " >>/data/1/tmp/310000.txt;
(printf "\xff\xfe" ; iconv -f utf-8 -t utf-16le /data/1/tmp/310000.txt) > /data/1/tmp/310000.csv;

4.數(shù)倉建設(shè)的一些資料

CMCC-LDM  模型設(shè)計(jì)   http://blog.itpub.net/23659908/viewspace-1118762/ 

數(shù)據(jù)倉庫模型設(shè)計(jì)  http://wenku.baidu.com/link?url=uTUGTvR05DN_u2AONeuT_XwDrt6HnBxtVJVFqAO8b0soG6FT8VmjWApWRGFdSfmgnNf2bzDA-tu_pCi1X-me7nROQe-R5I-Q1Op8RnZgvi_ 

企業(yè)數(shù)據(jù)倉庫概要設(shè)計(jì)說明書
http://wenku.baidu.com/link?url=T0KZZbcRPEpzyNd9gDqvGeVNjJNwF2Qz5iyMC13oLGOayOu-YtFdRb50PNZSyTLy7M84at1dm23uCqQAlidUCEGGQqqc5OYKKB8BuILsWf3 

數(shù)據(jù)倉庫構(gòu)建步驟 https://www.douban.com/note/233806228/ 

數(shù)據(jù)倉庫總體設(shè)計(jì)報(bào)告 http://doc.mbalib.com/view/8b46dceb8f930d185dcbaecdceeba4ce.html 

數(shù)據(jù)倉庫模型設(shè)計(jì)說明書 http://download.csdn.net/detail/cyp_1990/8798713 

教你輕松掌握數(shù)據(jù)倉庫的規(guī)劃和構(gòu)建策略  http://www.studyems.com/network/50f84352caacbfef.html 

企業(yè)級(jí)數(shù)據(jù)倉庫構(gòu)建過程  http://www.cfc365.com/mjzl/itzl/yangjinyu/2015-08-19/13436.shtml