A Data Warehouse is the main repository of an organization's historical data, its corporate memory. It contains the raw material for management's decision support system. The critical factor leading to the use of a data warehouse is that a data analyst can perform complex queries and analysis, such as data mining, on the information without slowing down the operational systems.
Data Warehouse applications are designed primarily to support executives, senior managers, and business analysts in making complex business decisions. Data Warehouse applications provide the business community with access to accurate, consolidated information from various internal and external sources.
Topics Covered of Data Warehousing
Informatica is a widely used ETL tool for extracting the source data and loading it into the target after applying the required transformation and supporting all the steps of Extraction, Transformation and Load process. Informatica is an easy to use tool. You just need to drag and drop different objects (known as transformations) and design process flow for Data extraction transformation and load. These process flow diagrams are known as mappings. Once a mapping is made, it can be scheduled to run as and when required. In the background Informatica server takes care of fetching data from source, transforming it, & loading it to the target systems/databases. Informatica can communicate with all major data sources (mainframe/RDBMS/Flat Files/XML/VSM/SAP etc), can move/transform data between them. It can effectively join data from two distinct data. In all, Informatica has got the ability to effectively integrate heterogeneous data sources & converting raw data into useful information.
Cognos 8 Business Intelligence (BI) offers a single, strong BI reporting and analysis product for support of analytic and enterprise reporting. The product is strong in all three areas — analytic functionality, application development, and usability with comprehensive support for unification, internationalization, and open APIs, and strong support for OLAP, query, metadata, dashboards, and scorecards. Cognos is one of a growing number of vendors — including Actuate, Business Objects, Hyperion, Microsoft, and MicroStrategy — that offer both analytic and enterprise reporting capabilities. However, Cognos 8 BI is a completely new, Web-based product that incorporates much of the functionality from Cognos legacy BI products such as PowerPlay, Metrics Manager, Impromptu, ReportNet, and others. Cognos is a leader in both analytic and enterprise reporting.
The Cognos Banking Risk Performance application provides a simplified risk performance process to detect, control, and optimize risks. It is an agile packaged solution that includes predefined warehouse and target models mapped to the IBM Banking Data Warehouse, best practice analytic reports, and dashboards. The application is designed to provide banks with an efficient way to identify credit risk. It enables the bank to ensure that it is:
Originating loans that are in line with planned diversification
Maintaining delinquencies at or below the planned level
Managing past due funds as efficiently as possible
Maintaining capital and reporting according to Basel II requirements