Data Warehousing Solutions from SAP

With SAP NetWeaver Business Warehouse (SAP NetWeaver BW), you can tightly integrate data warehousing capabilities on a comprehensive and scalable platform, while leveraging best practices to drive business intelligence predicated on a single version of the truth. An edition of SAP NetWeaver BW powered by SAP HANA is also available to help you supercharge your enterprise data warehouse, simplify your IT landscape, and enable your business users to make decisions faster. By combining a scalable and layered architecture, a rich set of predefined business content based on established best practices, and key ...

Informatica Strikes a Big Data Partnership

Informatica this week inscribed another notch in its Big Data belt by inking a partnership agreement with MapR, one of the leading Hadoop distributions in the marketplace. The partnership further opens Hadoop to the sizable market of Informatica developers and provides a visual development environment for creating and running MapReduce jobs. The partnership is fairly standard by Hadoop terms. Informatica can connect to MapR via PowerExchange and apply PowerCenter functions to the extracted data, such as data quality rules, profiling functions, and transformations. Informatica also provides HParser, a visual development ...

COMPARATIVE ARCHITECTURES SEMINAR

For years there have been two leading approaches to building the data warehouse environment – DW 2.0 “hub and spoke” architecture and the dimensional model/bus architecture. Both architectures have their advantages and disadvantages. There are places where one approach fits best. Come hear Bill Inmon discuss the DW 2.0 approach and hear Scott Hirst discuss the dimensional modeling/bus architecture approach. Then, hear how the two architectures can be blended, yielding a “best of all worlds” approach. Bill Inmon is well known for articulating the hub and spoke, top down approach to building the data warehouse....

TDWI's Best of Business Intelligence Volume 9

Welcome to the ninth annual TDWI’s Best of Business Intelligence: A Year in Review. Each year we select a few of TDWI’s best, most well-received, hard-hitting articles, research, and information, and present them to you in this publication. Stephen Swoyer kicks off this issue with a review of major business intelligence (BI) developments. In “2011 in Review: From Tablets to Takeovers,” he names social BI and the success of tablets and mobile devices as some of 2011’s trends. Swoyer also calls 2011 “the year in which social media emerged as one of several forces … that will fundamentally transform BI as we know it.” In...

Repository query to fetch User groups and users in it.

Can somebody give me PowerCenter Repository query(Oracle/SQLServer) to fetch below; 1. Fetch a specific User group and its members. Eg: Group Grp1 has members usr1, usr2, usr3, usr4, and usr5. 2. Fetch a specific Relational connection name and who has what kind of access. Eg: Users usr1,usr2, and usr3 has R/W/X permission on Rel_Conn1. Or Groups grp1, grp2, and grp3 has R/X permission on Rel_Conn1 I tried OPB_USER_GROUP table, but couldn't find relevant information. Repository query to fetch User groups and users in it.hope this works--Find the group idselectOPB_GROUPS--find the users in the groupselect * fromOPB_USERSwhere...

FEATURED: Informatica 9 - How does it change the dynamics of IT Projects?

In my opinion, with the launch of Informatica 9, it looks like the role of the developers is brought down considerably as the Business users themselves are able to customize the data objects to their need. The development effort is also coming down, as the Logical Data Objects created can be deployed across any service like Virtual SQL Federator Service or a Web service, etc. Flexibility is alright, but what is the cost involved in training the Business users to customize the delivered objects? What is the change that is brought about in Informatica's flagship product, PowerCenter? Is version 9 mainly focused on the...

New Features of Informatica 9.0

Following are some new features introduced in Informatica 9.0 :1.  New Client tools:Informatica 9 includes the Informatica Developer and Informatica Analyst client tools.The Informatica Developer tool is eclipse-based and supports both data integration and data quality for enhanced productivity. The Informatica Analyst tool is a browser-based tool for analysts, stewards and line of business managers.  This tool supports data profiling, specifying and validating rules (Scorecards), and monitoring data quality.2. Informatica Administrator:The PowerCenter Administration Console has been renamed the Informatica Administrator.The...

Breaking News—Informatica Launches Version 9 of its Data Integration Platform

Informatica today announced version 9 of its data integration platform with the theme of "Enabling the Data-Driven Enterprise." The Informatica platform is a comprehensive offering that provides for enterprise data integration, cloud data integration, B2B data exchange, and data quality across the whole enterprise. Major new features in version 9 of the platform focus on the areas of SOA-based data services, pervasive data quality, and Business-IT collaboration. Arvind Parthasarathi, vice president of product management for Informatica, tells 5 Minute Briefing that "the key elements of building a data-driven enterprise...

Deliver Complex Hierarchical Data Natively with Advanced XML Data Integration

The Informatica PowerCenter Advanced XML Data Integration Option enables real-time access to hierarchical data otherwise locked in XML files and messages. This option handles all XML data integration challenges, including integration complexity, visibility into hierarchical data, high-performance requirements, and maintenance related to frequent changes. With this XML data integration option, your IT organization can natively access, parse, and create any XML file based on any XSD—including data locked in complex schemas, deep hierarchical structures, and large XML files.     Easily incorporate complex XML...

Structure, Semantics and Master Data Models

Looking back at some of my Informatica Perspectives posts over the past year or so, I reflected on some common themes about data management and data governance, especially in the context of master data management and particularly, master data models. As both the tools and the practices around MDM mature, we have seen some disillusionment in attempts to deploy an MDM solution, with our customers noting that they continue to hit bumps in the road in the technical implementation associated with both master data consolidation and then with publication of shared master data.Almost every issue we see can be characterized into one...

New Features of Informatica-9

1. Informatica 9 supports data integration for the cloud as well as on premise. You can integrate the data in cloud applications, as well as run Informatica 9 on cloud infrastructure.2. Informatica analyst is a new tool available in Informatica 9.3. There is architectural difference in Informatica 9 compared to previous version.4. Browser based tool for business analyst is a new feature.5. Data steward is a new feature.6. Allows unified administration with a new admin console that enables you to manage power centre and power exchange from the same console.7. Powerful new capabilities for data quality.8. Single admin console...

Informatica 9 New Features

Power center 9 new features.PowerCenter Effective in version 9.0, PowerCenter contains new features and enhancements.Integration ServiceSession 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.  LicensingEnforcement of licensing restrictions. PowerCenter will enforce the licensing restrictions on the number of CPUs and repositories.  Lookup TransformationCache updates. You can update the lookup cache based on the results of an expression. When an expression is true, you can add...

Architectural difference between Informatica 9 and Informatica 8.x

Lookup Transformation: Cache updates. We can update the lookup cache based on the results of an expression. When an expression is true, We can add to or update the lookup cache. We can update the dynamic lookup cache with the results of an expression. Multiple rows return: We 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 We could create a SQL override for cached lookups only. We can create an SQL override...