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
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