Relative Content

Tag Archive for informaticainformatica-powercenter

REG_MATCH and REPLACESTR function in Informatica to replace a suffix character

We have a Business scenario where the Source Data is getting populated as ‘FIRST FINANCIAL SECURITIES OF AMERICA I’ where ‘I’ is getting populated as suffix . We need to remove the character ‘I’ from suffix and derive the data as ‘FIRST FINANCIAL SECURITIES OF AMERICA’ but when we use the below code in the expression transformation it is removing the character ‘I’ for all occurrence and gives the following out put string ‘FRST FNANCAL SECURTES OF AMERCA’. Can anyone please help me out in achieving the above logic using REG_MATCH and REPLACESTR ?

IIF Statement in Informatica with AND condition

We have a Business Scenario where we need to use a IIF statement in expression Transformation to Satisfy the below mentioned Logic , Can any one please help me on how this can be Achieved in Informatica?