In D & A Projects, building efficient SQL Queries is critical to achieving the Extraction and Load Batch cycles to complete faster and to meet the desired SLAs. The below observations are towards following the approaches to ensure writing SQL queries that meet the Best Practices to facilitate performance improvements. Tuning Approach Pre-Requisite Checks Before […]
Posts Tagged ‘tuning’
Performance Tuning Guidelines – Informatica PowerCenter
Quite often, while building the Data Integration Pipeline, Performance is a critical factor. The factors below are vital for following the guidelines while working on ETL processing with Informatica PowerCenter. The following items are to be considered during ETL DEV: Pre-Requisite Checks and Analysis Basic Tuning Guidelines Additional Tuning Practices Tuning Approach Pre-Requisite Checks/Analysis Before […]
IBM RedPaper on Caching with IBM Portal and DataPower XC10
@ansmt tweeted about this and I found it interesting. IBM has a Redpaper out about caching using IBM Portal and DataPower XC10. Many may think of a portal as a vibrant community with lots of changing content, ratings, tags, and applications. However, the reality is that most sites these days have some level of content […]