Moving from access DB to Oracle to calculate average upon request
-
Hi! We are re-writing existing access DB process into Oracle. With that said, we need to calculate averages upon request. The data is loaded everyday through datawarehouse. We would need to store amount value everyday, maybe into another table, and be able to calculate the average upon request? Just have a table listing the key fields in addition to date and amount? with date and amount changing everyday? Is there any other option to do this? If it were SQL server, I could have explored the SSIS packages. Not sure in Oracle. thank you!
-
Hi! We are re-writing existing access DB process into Oracle. With that said, we need to calculate averages upon request. The data is loaded everyday through datawarehouse. We would need to store amount value everyday, maybe into another table, and be able to calculate the average upon request? Just have a table listing the key fields in addition to date and amount? with date and amount changing everyday? Is there any other option to do this? If it were SQL server, I could have explored the SSIS packages. Not sure in Oracle. thank you!
You ask "your" users what sort of queries they "typically" deal with; and (re)design your data warehouse based on that. This isn't something you base on opinions gathered in the wild.
The Master said, 'Am I indeed possessed of knowledge? I am not knowing. But if a mean person, who appears quite empty-like, ask anything of me, I set it forth from one end to the other, and exhaust it.' ― Confucian Analects