全部博文(69)
发布时间:2017-10-30 03:18:46
SELECT SUBSTR(TABSCHEMA,1,18) TABSCHEMA,SUBSTR(TABNAME,1,30) TABNAME,(DATA_OBJECT_P_SIZE + INDEX_OBJECT_P_SIZE + LONG_OBJECT_P_SIZE + LOB_OBJECT_P_SIZE + XML_OBJECT_P_SIZE) AS TOTAL_SIZE_IN_KB,(DATA_OBJECT_P_SIZE + INDEX_OBJECT_P_SIZE + LONG_OBJECT_P_SIZE + LOB_OBJECT_P_SIZE + XML_OBJECT_P_SIZE)/.........【阅读全文】
发布时间:2016-12-28 16:49:52
In SSIS when extract data from sources, data flow error output has 3 columns - Flat File Source error Output Column, ErrorCode, ErrorColumnErrorCode is a numeric code, we can use script component to do the transformation into Error Description byGetErrorDescriptionIDTSComponentMetaData100Component.........【阅读全文】
发布时间:2016-10-08 10:36:39
When we already have a data warehouse, why we need to create OLAP Cubes?1. Quick Response -- Data already aggregated for performance2. Easy navigation -- drill down, slice, dice3.Easily use Excel to view data via Pivot Tables4. Security: You can use the security setting to give end-users .........【阅读全文】
发布时间:2016-10-07 01:08:59
There are several Operations in OLAP, which are : Roll-up, Drill-down, Slice or Dice and Pivot.Roll-up (Aggregation)dimension reduction, e.g. total sales by countrysummarization over aggregation hierarchy, e.g. total sales by city and year, totals sales by region and by yeaDrill-d.........【阅读全文】