WhereScape RED Room for Improvement
BI Analyst DW Architect at a mining and metals company with 10,001+ employees
The scheduling part I don't like due to the fact that it allows you to schedule as a parent and child and other things, however, the error trackability has to be a little more user-friendly.
It's also not user-friendly in the sense that it loads all the jobs and there are not enough filters so that it doesn't need to load everything.
If the job fails, you don't get any type of alert or email. It would be ideal if there was some sort of automated alert message.
Technical support isn't the best.
It would be ideal if we understood how to do it in a card exception regarding exclusion, where the card is captured separately rather than filling the whole process on the data inbound side. Certain workloads like this are organized in such a way where you seem to be doubling the work as opposed to streamlining the process.
Project-based searching of data objects in the data warehouse browser needs to be improved. When processing stage (work) tables if there are a lot then one has to scroll through a larger list. There is an ability to have projects or subject areas for processing that if applied to source tables would speed development.
On a separate note - those who have criticized this project for having a row based cursor and thus inefficient approach have not understood how the product works. I have used it for 10ish years and >99% of my processing is set based and efficient and supported by the product. It explicitly asks for set based vs row-based processing.View full review »
Manager IT - Business Intelligence & Analytics at a manufacturing company with 10,001+ employees
Customization could be better. When you need to modify or write some custom code, it can get a little messy. Performance can also be better. It would be nice to have synchronicity when integrating multiple tools.