top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Do we have any article on Informatica PowerCenter best practices?

+1 vote
457 views

Please share any pointers.

posted Sep 17, 2013 by anonymous

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button
I have shared few Informatica PowerCenter related articles. If those articles are useful for you then you can refer them.

Those can be found at
http://tech.queryhome.com/tag/informatica?sort=articles

Similar Questions
+1 vote

New to Informatica, want to install on windows 8 machine. Please suggest the version and the steps to install Informatica on Win 8.

+6 votes

I have this query say

Select A, B from Language.Alphabet

Where Language is my Schema Name, this query is used in Informatica Source Qualifier. This query is in Dev at this point so as I go to QA and Prod, the schema name needs to be changed, so rather than going to the query all the time I would like to change the schema name from our scheduling tool DAC.

I tried to parametrize this in Informatica by creating a parameter file and placing it on Informatica server, I get the desired results from this but only if I execute the workflow from Workflow Monitor and not from DAC, but I want it to be done from DAC.

+5 votes

I want to extract the number(0-9) from the string. e.g. if src is *Ax456*&56 then dst should be 45656.

+6 votes

Im working in a project which we create hundreds of xml's in informatica everyday, and all the data which is in the xml should be filtered, like removing all kind of special characters like * +.. You get the idea.

Adding regular expressions for every port is too complicated and not possible due the large amount of mapping we have.

I've added a custom property to the session XMLAnyTypeToString=Yes; and now i get some of the characters instead of &abcd, in their usual presentation (" + , ..).

I'm hoping for some custom property or change in XML target to remove these characters completely. any idea?

...