全部博文(69)
发布时间: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.........【阅读全文】
发布时间:2016-09-16 10:53:02
Join versus lookup Version 8.7.0 Version 11.5.0 Version 11.3.0 Version 9.1.0 Version 8.5.0 Version 8.1.0 InfoSphere? DataStage? does not know how large your data is, so cannot make an informed choice whether to combine da.........【阅读全文】
发布时间:2015-03-19 05:56:35
http://datawarehouse4u.info/SCD-Slowly-Changing-Dimensions.htmlThis is the most understandable description of SCD:What are Slowly Changing Dimensions? Slowly Changing Dimensions (SCD) - dimensions that change slowly over time, rather than changing on regular schedule, .........【阅读全文】