Data Integration - Informatica

Informatica Perspectives

Applying Retention Schedules To Database Data

Julie LocknerOver the last few blogs, we have stepped through a project to implement Information Lifecycle Management (ILM) on corporate databases.  First, we evaluated the target databases, then we determined the Business Objects and assigned retention periods to the data – including both Legal and Operational requirements.  Now that we are ready to start applying the retention policies and deleting data, it is a good idea to set up an archive database as an intermediate repository for business objects classified as legal records.
[Read more]

No Comments

Data as an Asset Part 7: The Future - Agile Data-Driven Enterprises

John Schmidt This is the last of the Data as an Asset series and what better way to wrap up the theme than with a view to the future. As stated by Thomas Redman, author of Data Driven, “Your company's data is a key business asset, and you need to manage it aggressively and professionally.” The future vision then is around Agile Data-Driven Enterprises. [Read more]

No Comments

Assessing Database Data For ILM

Julie LocknerA key benefit of implementing an Application Information Lifecycle Management (ILM) project is to reduce the amount of structured data in the data center.  Application ILM is a combination of a strategy and process that assesses information based on its business value and aligns the technology it resides on.  This process assures that the data center does not over allocate IT resources if the business doesn’t need it.  And likewise, if the business can provide detailed requirements for what it needs for its data, the IT department has a better idea of its technology forecasting needs.  Application ILM is a capacity planner’s friend.

[Read more]

No Comments

The Flip Side Of Data Assets: Data As A Liability

John SchmidtContinuing with the Data as Asset series, in this posting I explore the negative side and what can happen when data becomes a liability. Physical assets such as buildings, equipment, or even money, can become a liability if not managed properly; buildings can become unsafe to work in, machinery can be dangerous to operate, and business investments can turn into money-sinks. Similarly, data and information systems can also be assets that provide economic value to the enterprise or they can be liabilities that destroy value or put the business at risk if not managed well. Here are three common scenarios. [Read more]

No Comments

Data Governance, MDM - The Near And Far

Walid el AbedBusiness modernization programs typically focus on process standardization to gain the benefits of efficient repeatable, measurable processes. Enterprise resource planning (ERP) technologies fulfill the process standardization requirements and have now become a central point for management of business processes. However, ERP systems do not prevent low quality data from entering the systems nor do they measure its impact on the efficiency of a business process. Most organizations today are using the same ERP systems (SAP or Oracle) that were configured by the same consultancies. Therefore, the uniqueness and the scope for competitive advantage of any organization are defined by the people and the data. [Read more]

No Comments

Data as an Asset Part 5: Case Study In Managing Data Assets

John SchmidtMy last post on this theme A Market-based Approach To Valuing Data, introduced the idea of establishing an internal data economy as a way to value and manage data assets. Here now is a specific scenario for how this could work. I apologize in advance for the length of the posting, so please bear with me. The level of detail is necessary to demonstrate how an internal market can function in a practical manner. [Read more]

3 Comments

Let's Talk Collaborative Data Integration

Julianna DeLua

With all the chatter on the state of business and IT alignment, it is an opportune time for us to rethink the real-world implications of collaborative data integration. In a webinar on March 16th, Philip Russom of TDWI Research will discuss best practices and solutions that foster collaboration among the technical and business people involved in data integration. From my recent interactions with business analysts, I heard rave reviews on Informatica’s analyst-ready, data profiling tools and new workflow enhancements of Informatica business glossary introduced with Informatica 9. In this Informatica-sponsored webinar, we are tapping our own, Diby Malakar, who championed the business-IT collaboration solution for our Informatica 9 launch.

[Read more]

No Comments

Are You Getting What You Expected From Your Anti-Money Laundering Software?

Peter Ku According to a recent FT.com article, US lawmakers are seeking to expand the reach of anti-money laundering regulations after a Senate investigation found that hundreds of millions of dollars in suspect foreign funds have been able to land in the US. As we can see, money laundering and terroristic financing continues to rise despite the huge investments banks have made in packaged Anti-Money Laundering (AML) software, custom built solutions through global system integrators, re-engineered business process, people, and policies.  How can this be? Were these bad investments to begin with or is there something else causes these issues? [Read more]

No Comments

And The Award Goes To…

Julianna DeLua

Komerční banka.

Fresh off a flight from London, Dave Schrader, our friend from Teradata, alerted me that our joint Teradata-Informatica customer, Komerční banka, a Société Générale bank, won the prestigious, EMEA Business Intelligence Award 2010 at Gartner Business Intelligence Summit!

In their press release,
http://www.kb.cz/en/com/press/releases/781.shtml

Pavel Čejka, Komerční banka Executive Director, Strategy and Finance, comments on the great benefits of BI: "I believe that one of the strengths of financial management at KB is the existence of a unified database and performance indicators, which are interconnected and focused not only on financial data, which I consider to be a matter of course, but also on business, product, risk, operating and other information."

Teradata and Informatica were highlighted as part of the first-class technologies in the project. It involved the implementation of user metadata and an information quality program. [Read more]

No Comments

Solving FAS 166 And 167 Compliance With Data Integration And Data Quality

Peter Ku Back in June 2009, the Financial Accounting Standards Board (FASB) published Financial Accounting Statements No. 166, Accounting for Transfers of Financial Assets, and No. 167, Amendments to FASB Interpretation No. 46(R), which changes the way entities account for securitizations and special-purpose entities. The new standards will impact financial institution balance sheets beginning in 2010 and will require substantive changes to how banks account for many items, including securitized assets that had been previously excluded from these organizations' balance sheets. Banks affected by the new accounting standards will be subject to higher risk-based regulatory capital requirements. So what does it all mean and how much will it cost banks to comply?  [Read more]

1 Comment

Next,