Integration Service
Session log file rollover. You can limit the size of session logs for real-time sessions. You can limit the size by time or by file size. You can also limit the number of log files for a session.
Licensing
Enforcement of licensing restrictions. PowerCenter will enforce the licensing restrictions on the number of CPUs and repositories.
Lookup Transformation
Cache updates. You can update the lookup cache based on the results of an expression. When an expression is true, you can add to or update the lookup cache. You can update the dynamic lookup cache with the results of an expression. Database deadlock resilience. In previous releases, when the Integration Service encountered a database deadlock during a lookup, the session failed. Effective in 9.0, the session will not fail. When a deadlock occurs, the Integration Service attempts to run the last statement in a lookup. You can configure the number of retry attempts and time period between attempts. Multiple rows return. You can configure the Lookup transformation to return all rows that match a lookup condition. A Lookup transformation is an active transformation when it can return more than one row for any given input row. SQL overrides for uncached lookups. In previous versions you could create a SQL override for cached lookups only. You can create an SQL override for uncached lookup. You can include lookup ports in the SQL query.
Mapping Architect for Visio
New mapping objects. You can include the following objects in a mapping template: Pipeline Normalizer transformation Custom transformation PowerExchange source definition PowerExchange target definition
You can also create a mapping template from a mapping that contains these objects.
Shortcuts. You can configure a transformation to use a shortcut. You can create a mapping template from a mapping that contains shortcuts to reusable transformations.
SQL Transformation
Auto-commit for connections. You can enable auto-commit for each database connection. Each SQL statement in a query defines a transaction. A commit occurs when the SQL statement completes or the next statement is executed, whichever comes first. Exactly-once processing. The Integration Service provides exactly-once delivery of real-time source messages to the SQL transformation. If there is an interruption in processing, the Integration Service can recover without requiring the message to be sent again. To perform exactly-once processing, the Integration Service stores a set of operations for a checkpoint in the PM_REC_STATE table. Passive transformation. You can configure the SQL transformation to run in passive mode instead of active mode. When the SQL transformation runs in passive mode, the SQL transformation returns one output row for each input row.
XML Transformation
XML Parser buffer validation. The XML Parser transformation can validate an XML document against a schema. The XML Parser transformation routes invalid XML to an error port. When the XML is not valid, the XML Parser transformation routes the XML and the error messages to a separate output group that you can connect to a target.
Starting from Version 9 , powercenter admin console is called as informatica administrator.
Informatica Administrator (PowerCenter Administration Console) Effective in version 9.0, the PowerCenter Administration Console is renamed to Informatica Administrator. The Informatica Administrator has a new interface. Some of the properties and configuration tasks from the PowerCenter Administration Console have been moved to different locations in Informatica Administrator. The Informatica Administrator is expanded to include new services and objects.
Analyst Service. Application service that runs Informatica Analyst in the Informatica domain. Create and enable an Analyst Service on the Domain tab of Informatica Administrator. When you enable the Analyst Service, the Service Manager starts Informatica Analyst. You can open Informatica Analyst from Informatica Administrator. Data Integration Service. Application service that processes requests from Informatica Analyst and Informatica Developer to preview or run data profiles and mappings. It also generates data previews for SQL data services and runs SQL queries against the virtual views in an SQL data service. Create and enable a Data Integration Service on the Domain tab of Informatica Administrator. Model Repository Service. Application service that manages the Model repository. The Model repository is a relational database that stores the metadata for projects created in Informatica Analyst and Informatica Designer. The Model repository also stores run-time and configuration information for applications deployed to a Data Integration Service. Create and enable a Model Repository Service on the Domain tab of Informatica Administrator. PowerExchange Listener Service. Manages the PowerExchange Listener for bulk data movement and change data capture. The PowerCenter Integration Service connects to the PowerExchange Listener through the Listener Service. PowerExchange Logger Service. Manages the PowerExchange Logger for Linux, UNIX, and Windows to capture change data and write it to the PowerExchange Logger Log files. Change data can originate from DB2 recovery logs, Oracle redo logs, a Microsoft SQL Server distribution database, or data sources on an i5/OS or z/OS system. Connection management. Database connections are centralized in the domain. You can create and view database connections in Informatica Administrator, Informatica Developer, or Informatica Analyst. Create, view, edit, and grant permissions on database connections in Informatica Administrator. Deployment. You can deploy, enable, and configure deployment units in the Informatica Administrator. Deploy Deployment units to one or more Data Integration Services. Create deployment units in Informatica Developer. Monitoring. You can monitor profile jobs, scorecard jobs, preview jobs, mapping jobs, and SQL Data Services for each Data Integration Service. View the status of each monitored object on the Monitoring tab of Informatica Administrator
Thursday, December 16, 2010
New features of Cognos 10
New things in Cognos 10
Life Cycle Management is the capability to handle upgrades from one version to another. They made a big deal of this at last week’s event. No doubt in an attempt to pre-empt the groans from those in the audience that remember all too well the pain associated with version upgrades in the past. It appears that they have done a lot of work to make this process uneventful. Plus, it’s now possible to run reports and queries in both Cognos 8 and 10 at the same time and then compare the processing differences. This should reduce the testing needed in version upgrades.
Dynamic Query is a new feature that results from performance enhancements. With this feature enabled, reports, queries and cube building are shortened. This is done by caching and query routing techniques. Results indicated performance improvements of up to 30 to 40 percent.
Statistical Integration is the result of SPSS being integrated into the analytics umbrella of Cognos 10. Based on what I saw, the future of this looks impressive indeed. SPSS has added a Modeler capability making it easier for non-statisticians to benefit from predictive modeling in a much broader business context. increasing the potential for improved business performance. Those with the skills to harness its power can get some big benefits quickly.
Active Reports allow users to receive self-contained interactive reports by email. This extends the reach of BI to mobile and offline workers that can work on these active reports and perform what-if scenarios if required. Mobile workers are the fastest growing market segment for BI and making it easier for them to work anywhere keeps the market growing.
Platform Enhancements designed to make life easier for those that have to support the platform. These include optimized query generation, life cycle management and performance enhancements. As BI environments have grown in size throughput has become more of an issue. These enhancements help minimize potential bottlenecks as more users are added to the environment.
Social Networking is achieved with the integration of Lotus Connections and Business Analytics. With Cognos 10, key information can be shared by groups or communities and forms the basis for decision making that connects people to the event. All of this is captured and used to improve decision making practices.
Life Cycle Management is the capability to handle upgrades from one version to another. They made a big deal of this at last week’s event. No doubt in an attempt to pre-empt the groans from those in the audience that remember all too well the pain associated with version upgrades in the past. It appears that they have done a lot of work to make this process uneventful. Plus, it’s now possible to run reports and queries in both Cognos 8 and 10 at the same time and then compare the processing differences. This should reduce the testing needed in version upgrades.
Dynamic Query is a new feature that results from performance enhancements. With this feature enabled, reports, queries and cube building are shortened. This is done by caching and query routing techniques. Results indicated performance improvements of up to 30 to 40 percent.
Statistical Integration is the result of SPSS being integrated into the analytics umbrella of Cognos 10. Based on what I saw, the future of this looks impressive indeed. SPSS has added a Modeler capability making it easier for non-statisticians to benefit from predictive modeling in a much broader business context. increasing the potential for improved business performance. Those with the skills to harness its power can get some big benefits quickly.
Active Reports allow users to receive self-contained interactive reports by email. This extends the reach of BI to mobile and offline workers that can work on these active reports and perform what-if scenarios if required. Mobile workers are the fastest growing market segment for BI and making it easier for them to work anywhere keeps the market growing.
Platform Enhancements designed to make life easier for those that have to support the platform. These include optimized query generation, life cycle management and performance enhancements. As BI environments have grown in size throughput has become more of an issue. These enhancements help minimize potential bottlenecks as more users are added to the environment.
Social Networking is achieved with the integration of Lotus Connections and Business Analytics. With Cognos 10, key information can be shared by groups or communities and forms the basis for decision making that connects people to the event. All of this is captured and used to improve decision making practices.
Subscribe to:
Comments (Atom)
Posts
