Best Practise to populate Fact and Dimension Tables from Transactional Flat DB

Posted by alex25 on Stack Overflow See other posts from Stack Overflow or by alex25
Published on 2010-03-21T17:38:29Z Indexed on 2010/03/21 17:41 UTC
Read the original article Hit count: 475

Filed under:
|
|
|
|

Hi!

I want to populate a star schema / cube in SSIS / SSAS.

I prepared all my dimension tables and my fact table, primary keys etc.

The source is a 'flat' (item level) table and my problem is now how to split it up and get it from one into the respective tables.

I did a fair bit of googling but couldn't find a satisfying solution to the problem. One would imagine that this is a rather common problem/situation in BI development?!

Thanks, alexl

© Stack Overflow or respective owner

Related posts about ssis

Related posts about businessintelligence