Hi ,
I get only Transaction details like (Transaction No,Cost Center,Employee,Flight,Total Money Spent etc) from legacy system as a CSV file.
How do I model my warehousing?
Which would be a better design for info providers?
DSO would be sufficient or can i model cubes by loading master data form transaction data?
or any other suggestion?
Thanks and Regards,
MuraliManohar.