Best Practise to populate Fact and Dimension Tables from Transactional Flat DB
- by alex25
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