August 5, 2024 at 8:29 pm
Hi our corporate level warehouse currently sits on sql server 2019 standard where some cubes also reside alongside ssis and ssrs.
i dont know if our individual erp's/locations have their own warehouses too. But we currently summarize their procurement and sales data in that corporate level wh. other areas of the business like labor are on our radar as well.
Our oracle account manager tells us the datasets (semantic models) in their netsuite warehouse product compare favorably performance wise to our cubes. he says thats not because of anything like the vertipac engine but rather ocpu's (presumably a term for oracle cpu's) . while we expect to double the volume in those cubes thru aquisition shortly, we currently have only 55 million rows in the sales cube.
we will be purchasing what i believe is their first tier product which comes with 2 ocpu's.
does the community feel that their entry level product will give the ms stack a run for the money? Oracle claims their product is like snowflake in architecture.
August 6, 2024 at 9:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply