Informatica: How do you optimized QlikView application? What Tools are used and where do you start?

Question

Can we use Hadoop as a substitue for ETL tools like Informatica for ETL processes ?

Answer 1

For Optimization we can optimized the QVD which is used in the QVW files in the backend. For QVW optimization i believe not use any tools we can manually remove unwanted fields form data model or comment it, remove most complex logics from the load script or create it with the simple way because it will take long time for loading. If using large data base file try to create the incremental load for the QVD or load latest data only.