Find solution
What is selling these days?

To find the products which are listed in the top 10 best selling products every month or to select the stocks rising for 5 days consecutively, how do you deal with data oriented problems in application or report development?

  • To find the products which are listed in the top 10 best selling products every month or to select the stocks rising for 5 days consecutively, how do you deal with data oriented problems in application or report development?

  • Answer:

    If the logic is mildly complex, I suggest using an ETL solution such as Pentaho Data Integration (Spoon sometimes does wonders). You can create projects composed of processes whose flow is clearly depicted and thus maintainable. It also solves the problem of loading and transforming -- you can access the database(s) directly and produce your output in (nearly) whatever format you like, besides automating backups, history keeping and publishing.

Gui Pinhata Nami at Quora Visit the source

Was this solution helpful to you?

Other answers

Hi, Gui, I think ETL can just let these problems happen in another position( into ETL procedure), while can not make them disappear.Such complex computing I mentioned  is not to simply integrate the data, but also involves a lot of business rules, general ETL tools can hardly deal with them, and usually scripting is necessary. I'm not sure if you ever tried esProc script, it is much easier than most of ETL tools for such complex problems. Furthermore, report often needs to present the database in real time, and cann't always be waited to review the results until ETL operation ends.

Davina May

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.