We are implementing Sales data into the DW. We at the requirement analysis stage. How do you handle sales history data? I am getting input in various forms as Excel Spread Sheet, XML format. We are planning to use Oracle 10g as database and .Net for reporting. We should have a option of import/exporting data into/from excel sheet.
Would like to hear some thoughts/advice on modeling (star schema). Any input appreciated!
Would like to hear some thoughts/advice on modeling (star schema). Any input appreciated!