Informatica

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 […]

Scenario We want to create a target flat file name with the current system date. Solution 1 The first method is renaming the target file name in the post session command as bellow: Example: The following command will rename the file in the format filename_MMDDYYYY.out in Windows: move $PMTargetFileDir\filename $PMTargetFileDir\filename_%date:~4,2%%date:~7,2%%date:~10%.out

I remember that I heard the cloud concept about ten years ago while now the real cloud age is here. The cloud deployment and practice in CRM area might be the pioneer comparing with others. It is glad that we are seeing more and more BI vendors are boosting their cloud strategy and product development […]

The need to change the values actually being imported is inevitable when you are importing data into Salesforce. Scary to some, a matter of fact to most , but a way to shine for the users of Informatica . At Perficient we have been able to use the cloud tool Informatica which offers a wide […]

Perficient clients are able to leverage a wide range of tools across the broad spectrum of current technologies. Through the course of my experience with Perficient’s Salesforce team I have been able to help implement different types of technical solutions. My blog posts will focus in on various solutions, and I will start with the […]

Duplicate records are occasionally found in source data. Due to primary key constraints on a target database, only one version of a duplicate source record should be loaded into the target. The following methods demonstrate some of the most efficient ways to deal with duplicate source data. 1. Aggregator Transformation When to use Any time […]

Target update override is also like source qualifier override. It is useful to update the target without using the update strategy transformation. You can find the Target Update Override option in the target definition properties tab. The syntax of update statement to be specified in Target Update Override is UDATE TARGET_TABLE_NAME SET TARGET_COLUMN1 = :TU.TARGET_PORT1, […]

  Scenario: Data source is a flat file and we want to load this data into the target. The problem is the source file name keeps on changing.  Here we go: Use a pre-session script that creates a file list. Windows dir /b part_of_file_name*.txt > FILELIST_NAME.LST UNIX ls part_of_file_name* > FILELIST_NAME.LST                 In Workflow Manager […]