Qlikview in-memory pros & cons

[#1]

QW has in-memory store which compress huge data and saved in server either in QVD or QW format. But does QW ETL is effective for large databases of pita bites.

Does QW supports other ETL and DW concepts like 1. SSIS(ETL)--->SSAS(Cubes) or 2..IBM Informatica(Cubes). From this Analise DB cubes can QW dashboard pick data and store in QVD and refresh dashboards from QVD but not the oparational/Production database.

QW as reporting tool and  other DW tools for ETL.

[Gysbert_Wassenaar]

Perhaps this blog post can shed some light: http://community.qlik.com/blogs/theqlikviewblog/2010/10/13/qlikview-under-the-hood. Also check out QlikView Architectural Overview whitepaper. You can find that document in this discussion too: Qlikview Architecture