原站：http://forum.kimballgroup.com/...-and-data-quality-f9/-t1.htm

“ETL and Data Quality”的内容更新

累计：208 篇（自 2009-09-18 起）

更新：约2篇/周，最后更新10 天前

ETL and Data Quality

Loading Duration Data

hi all, i'm faced with what must be quite a common problem.our transactional system stores downtime for a machine as a start date and duration.our time dimension has days at the lowest level (rolled up to months and years).i'm using ssis to load data to a fact table and would like thoughts on how to break a 'duration' of say 72 hours into days in the ... (10 天前)

http://inezha.com/w/odc5ark

ETL and Data Quality

Microsoft Metadata Management

what is the best way to store and make available to end users business metadata related to conformed dimension attribute definitions within microsoft products (tables, view, and or olap/analysis services)?... (13 天前)

http://inezha.com/w/jf3vdr3

ETL and Data Quality

loading facts from dimensions in Informatica

hi all,i'm praneeth . i'm new to data warehousing. i'd been working on informatica for the last two weeks.i'm familiar with almost all transformations.but i'm facing problem when loading fact table from dimension tables.could you help me in knowing the right process to load facts and dimensions && facts from dimensions.thanks in advance,praneet... (16 天前)

http://inezha.com/w/h7ancrg

ETL and Data Quality

SSIS Audit Dimension Microsoft Data Warehouse Toolki

i am playing around with the sample packages for the microsoft kimball toolkit 2008 and i have noticed a couple of things which are not a huge deal but was wondering if anyone else has seen them or whether i am missing something. all the sample packages add a row to the audit dimension and the audit dimension has a column for parentaduitkey which is a f... (20 天前)

http://inezha.com/w/gccomrb

ETL and Data Quality

Adding a new Dimension to the Star-Schema

dear experts,i?m currently handling with a for me not-solvable problem. i want to add/implement a new dimension to my star-schema. the fact table is already connected throw surrogate keys to several dimensions. a few of the dimension tables are implemented as scd-2 dimensions.to add a new dimension means for me to change the ddl-structure of the fact... (20 天前)

http://inezha.com/w/u03y3rm

ETL and Data Quality

Incremental Loading of data

hi,in our gl_account dimension table, the data from source data base comes from 6 tables. we need to load the data incrementally into data mart using ssis. means, we want to load only the changed records using the sql server cdc feature. we have the server enabled with cdc. there is a account id which links the 4 tables. but the two table needs to be co... (23 天前)

http://inezha.com/w/zja4wrx

ETL and Data Quality

Creating Crosswalk Tables for Multiple Data Sources

good morning all, i am currently building a dw consisting primarily of medical data. we have several disparate systems in house that contain the same type of information (for this example, i'll use person). in addition, we regularly receive data from several external organizations that is needed in our reports. in some cases there is already a linking t... (23 天前)

http://inezha.com/w/q9cmai1

订阅者 ( 1 )

相关订阅源