Informatica

Most of the enterprise data warehouse using Informatica PowerCenter to build the warehouse. After build the data warehouse and make it incremental load daily or several time per day. But data warehouse is not real time, it also has some gap between the source database and Target database. How can we make Data Warehouse Real […]

What is Hybrid SCD? Slowly Changing Dimension (SCD) Type 6 is also called as “Hybrid SCD” that combines three fundamental SCD techniques. Type 6 can be used when you want to maintain complete history and would also like to have an easy way to manage current version. The point of “type 6” or “Hybrid” processing […]

Informatica World wrapped up last week with some exciting product discussions, including Informatica Product 360, Data Governance, and Cloud Data Management. The Informatica Cloud product team entertained business and IT on the ease of use and time to value of data readiness using Informatica Cloud including Cloud Big Data, Cloud MDM, and Cloud Data Integration. […]

Day 2 at Informatica World has been equally as informative and exciting as day 1. The day started with Amit Wahlia (Chief Product Officer) discussing the 6 data disruptions leading to innovations that Informatica is watching – including mobile, social media, big data, IoT, security, and cloud. A cool example of data-driven disruption was Amazon […]

There were 3 main themes during day 1 of Informatica World 2016, including a data competency model, Data 3.0, and updates to their partnership program as a part of their efforts to bolster their collection of data-ready solutions. Since the emergence of Informatica 20+ years ago, their vision to become market leaders in data management […]

Cloud data management is a critical component to the effectiveness of your big data and analytics program. But you need the right tool and not all data management tools are optimized for cloud. There are six reasons on why customers use Informatica Cloud Data Management: 1. Agility and time to value: Informatica has done well to bring […]

A data governance plan begins with the acknowledgement that your organization needs a strategy to own and be responsible for data in order to make better decisions internally and externally. Without this in place, data can be misunderstood and misused, or worse, not used at all. As an Elite Informatica Partner, Perficient and Informatica work […]

Last week, Informatica hosted their annual world conference in Las Vegas, NV.  The title of the conference was “All Things Data”.  There were over 2,500 attendees at the conference, which included Informatica employees, partners, and clients.  There were four days of business and technical breakout sessions with a variety of topics from Big Data, Cloud, […]

A colleague posted on the Saleforce blog recently a brief post exemplifying why Informatica is a leader in real-time data integration. He writes… No secret or surprise that Informatica and Salesforce have been closely aligned and work very well together. Both are cloud solutions which free you from having to manage on-premise networks and access […]

For a company like LinkedIn, data is at the core of their business. Externally, subscribers to their network are constantly seeing content updated by the seconds. But what about internally? Their data teams are non-stop behind the scenes working to keep up with all of this rapidly changing data so when their Financial, Planning, & […]

https://www.youtube.com/watch?v=kOa9Eg9HeB8 System interoperability and integration is critical to healthcare organizations. Their ability to coordinate care across the continuum with integrated data solutions and streamlined data sharing supports population health management initiatives and makes accountable care a reality. Using Informatica Powercenter/ Powerexchange for Mainframes as an ETL tool, Perficient has helped healthcare organizations achieve enterprise-wide ODS’ […]

Problem Description: Several days ago when I ran a PowerCenter session, I encountered an issue of populating column value of money data type from one Microsoft SQL Server table to another. For example, the original source value is 1234.1250, but after I loaded it to another table, it became 1234.1136. In Informatica, the column data […]