Informatica has released its latest version 8.6 covering all the hot fixes it released for the prior version 8.5 and including few new features. Since version 8, a Unified Admin Console has been designed for managing Integration and Repository services. These were discussed in earlier Blogs.

What does PowerCenter 8.6 bring new for the developers? Let us discuss PowerCenter 8.6 Client enhancements which will be useful to the developers.

1. Creating Targets from Transformations

We can create targets based on transformations in the workspace or navigator.

To create a target,

1. Right-click the transformation in the workspace and select the Create and Add Target option.

2. Alternatively, we can drag and drop the transformation in the Target Designer.

The target that is created has the same port definitions as the transformation from which it was created. We can edit the target definitions later. In addition, the target type is the same as that of the repository used.

2. Invalid/Invalidated renamed

In PowerCenter 7, the two states of objects were known as Invalid and Invalidated.

The exact meaning of these states is as follows:

Invalid – an object will not run,

Invalidated – an object may be invalid or may not run.

The difference between the two terms was not very clear. Therefore, to avoid any confusion, in PowerCenter 8.6, the two states have been renamed as Invalid and Impacted. While the Invalid state still implies that an object will not run, Impacted means that an object is affected by a change, and therefore, may not run.

Apart from the naming convention the icons are also changed in PowerCenter 8.

3. Propagating Port Descriptions

In the Designer, in addition to the other properties of port propagation, we can edit a port description and propagate the description to other transformations in the mapping.

4. Environment SQL Enhancements

In PowerCenter 8, environment SQL can be used to execute an SQL statement at the beginning of each transaction. The Integration Service executes transaction environment SQL at the beginning of each transaction. Environment SQL can still be used to execute an SQL statement at each connection to the database.

Use SQL commands that depend upon a transaction being opened during the entire read or write process. For example, the following SQL command modifies how the session handles characters:

ALTER SESSION SET NLS_LENGTH_SEMANTICS=CHAR


5. Flat File Enhancements

PowerCenter 8 includes enhancements for handling flat files. Some of these improve performance.

Flat files can now use Integer or Double data types.

In addition, target partitions can be merged. The flat file target merge options include:

Posted by Rajamani Vasudevan
Comments (15)
September 25th, 2008

Comments (15)

poorna chandra chowdary - June 14th, 2010

no man a m sleeping

Badri Narayanan - November 26th, 2009

Sorry, it is not possible

Swapnil - November 25th, 2009

Hi ALL, Is it possible to connect Informatica 8.2 with patch server through Informatica 8.6 clients ? Please respond at the earliest.

sirini - October 1st, 2009

I solved my problem by reinstalling windows xp and now informatica is working without any issues. All the way I knew this but I was actually trying to make informatica work without reinstalling windows. I hope someone would come up with a solution for this.

Anantha - September 30th, 2009

Wow! At last some one has come up with a solution for this. Thanks for suggesting this Vinay. I'll try it and let you know.

Vinay Jaini - September 30th, 2009

I faced the same installation problem "the following error occurred while performing a repository action. Error – [PCSF_10007] Cannot connect to repository [InfoRep] because: [Failed to connect to repository service [InfoRep].]. This error occurs when TCP/IP ports which are supposed to use by Informatica, are being used by some other applications. To get rid off this error, I used partition magic tool and did the partition to my system and installed operating system in new partition , installed oracle 9i and installed Informatica 8.11, then It is working. In this partition I did not install any other software or tools, just installed operating system, oracle and informatica.

Anantha - June 22nd, 2009

Naveen, This error comes up in XP too. In fact, I've installed PC 8.6 on both Vista and XP. I'm getting the same error in both Operating Systems (Mine is a dual boot XP and Vista)

Naveen - June 19th, 2009

I got the same error. I have seen this issue if the operating system is Windows Vista. Does any one have it working on vista?

Anantha - June 5th, 2009

Hi Sirni, I'm getting the same error as well!! I've been trying hard for the last 4 days, but in vain. I believe it's a bug, not sure though. In case you come up with some solution, please let us know.

Sirini - May 27th, 2009

Hi I am still working on the above issue but with no result. As I was digging through the installlog file, I found a warning which says "Get Registry Entry: Key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\PerfProc\PerfProc\Performance, ValueName: Disable Performance Counters Status: WARNING Additional Notes: WARNING -Win32Exception The key here has to be HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\PerfProc\Performance. But I dont understand why it is taking it as 'PerfProc' in the place of 'Services'. Can anyone please tell me how to change this. Thankyou

Ram - May 15th, 2009

I am also getting the same error; I spent a week, trying to resolve this error. If any one fined the solution please share it here

Sam - April 12th, 2009

Hi Srini, Even I am having the same problem.I even tried unistalling and re installing Informatica ,but hasnt helped.Were you able to fix the problem? please let me know. Thanks, Sam

Satish - March 29th, 2009

Srini, I am getting the exact problem with informatica 8.1.1 install. Were you able to resolve it ? I really appreciate if you can post the solution. Thanks, Satish

Badri Narayanan - March 19th, 2009

Possible reasons, 1.Server had been applied with service pack and client not, could be vice versa 2. If have you migrated, should have migrated users and groups as well Please share more environmental info.

Sirini - March 3rd, 2009

Hi I came across your blog when I was searching for an Informatica installation error. I have installed Informatica 8.1 on oracle 10 g enterprise edition on my laptop without any issues. But I am not able to connect to the repository. When I try to access the repository service and integration service from the admin console the error message I am getting is "The following error occurred while performing a repository action. Error - [PCSF_10007] Cannot connect to repository [InfoRep] because: [Failed to connect to repository service [InfoRep].]." When I try to connect to any of the client tools the error message I get is "Unable to get license information for repository()" Error:[PCSF_10342][PCSF_10342]Exception occurred:[[PCSF_10007]Cannot connect to repository [InfoRep] because: [Failed to connect to repository service [InfoRep].]." I had been struggling with since 2 weeks and am unable to find the solution from anybody. I would be very greatful if you could help me with this issue.

Comments are closed.