Performance Testing Citrix Presentation Server™ Platform

Citrix Presentation Server™ provides dynamic solutions to information access issues, but presents potential complications that are unique to this platform. While you are confident that your decision to use Citrix will provide cost-efficient accessibility to necessary applications, your business and technical teams are wondering whether it will scale.  What do you do?  Conventional scalability/load/performance tools will not work with applications built with Citrix. Why? Because these tools have been built...

ETL ARCHITECTURES – CONCEPTS AND IMPLEMENTATION

ETL Architectures is an in-depth, technical course that teaches the concepts for designing and implementing the appropriate architectures to use in managing the extraction, transformation and loading (ETL) of data for: High performance decision support environments (data warehouses, dimensional data marts, Operational Data Stores (ODS), etc) Master Data Management hubs (Customer Data Integration (CDI), Product Information Management (PIM), etc) General data integration (e.g. Service Oriented Architectures (SOA)) This course will review these architectures and concepts with the primary focus on the concepts and techniques...

DataBase Tuning

With the advent of the e-commerce insurrection, much focus has been directed towards the web-based technology that supports the Internet, such as Java, HTTP, Web Services, XML, etc. The common thread to all of the new technologies is their dependency upon relational databases to provide data essential to their business paradigm. Database platforms such as Oracle9i, IBM DB2, Microsoft SQL Server and Sybase Adaptive Server Enterprisetherefore provide the core foundation upon which business decisions are made and revenue is produced.  Whether implementing an on-line transaction processing system...

ETL (Extract-Transform-Load) for Data Warehousing

Stocking the data warehouse with data is often the most time consuming task needed to make data warehousing and business intelligence a success. In the overall scheme of things Extract-Transform-Load (ETL) often requires about 70 percent of the total effort. Extracting data for the data warehouse includes:     Making ETL Architecture Choices     Data Mapping     Extracting data to staging area     Applying data cleansing transformations     Applying data consistency...

DATA WAREHOUSE TESTING IS DIFFERENT

All works in Data Warehouse population are mostly through batch runs. Therefore the testing is different from what is done in transaction systems. Unlike a typical transaction system, data warehouse testing is different on the following counts: User-Triggered vs. System triggered Most of the production/Source system testing is the processing of individual transactions, which are driven by some input from the users (Application Form, Servicing Request.). There are very few test cycles, which cover the system-triggered scenarios (Like billing, Valuation.) In data Warehouse, most of the testing is system triggered as per...

Various Types of Testimg

    XML Testing     Network Latency Modeling     Java Testing (J2EE/EJB)             Transaction Characterization     Data Integrity Testing             Load/Scalability Testing     GUI Testing             Performance Testing     Issue/Defect Tracking             Stress Testing     Requirements Management   ...

Testing the Data Warehouse

Testing the data warehouse and business intelligence system is critical to success.  Without testing, the data warehouse could produce incorrect answers and quickly lose the faith of the business intelligence users. Effective testing requires putting together the right processes, people and technology and deploying them in productive ways. Data Warehouse Testing Responsibilities Who should be involved with testing?  The right team is essential to success: Business Analysts gather and document requirements QA Testers develop and execute test plans and test scripts Infrastructure people set up test environments Developers...

FUNDAMENTALS OF DATA WAREHOUSE TESTING

Description This course introduces the student to the phases of testing and validation in a data warehouse or other decision support systems project.  Students will learn the role of the testing process as part of a software development project, see how business requirements become the foundation for testing cases and test plans, develop a testing strategy develop audience profiles and learn about how to develop and execute effective tests, all as part of a data warehouse / decision support initiative.  Students will be able to apply the data warehouse concepts in a series of related exercises that enable them to...