Informatica WRT_8410 Error, with [Error=]
In informatica I am getting this error
WRT_8410 : Error writing file [error=]
Unable to understand what’s causing this error.
Using a Command Task to create a shell to run the same workflow again in a loop using nohup
I know that the typical solution to have a recursive workflow call is to create 2 workflows and call each other until a condition is met and the workflow is ended.
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?
I want to generate Alphanumeric series in informatica, and the logic that I am trying isn’t working
I want to generate alphanumeric series like below using Informatica PowerCenter and I am stuck coming up with business logic for the same.