• SalesforceConnection-10122: Login failed. User .Fault code [SERVER_UNAVAILABLE]. Reason [server temporarily unavailable]."

    We are getting inconsistent behavior with Informatica Salesforce Connector . We get "HadoopBatchDTM-pool-4-thread-9262> SEVERE: SalesforceConnection-10122: Login failed. User []. Fault code [SERVER_UNAVAILABLE]. Re...
    Varadaraj Bhat
    last modified by Varadaraj Bhat
  • REG_MATCH expression

    Hello All,   My requirement for Target_Field_A is as follows: If Source_Field_A like ‘%ORGIN%’ then set ORIGIN,   Else if Source_Field_A like ‘%DEST%, then set DESTINATION.  ...
    Divya Karun
    last modified by Divya Karun
  • Developer Client 10.4.1 is not starting

    I have installed Informatca 10.4.1 and installed developer client. But Developer client is not opening. I have installed jdk 16 also. I have checked metadata logs, below error is showing. Attached metadata logs. Pleas...
    Rajesh Audhivanne
    last modified by Rajesh Audhivanne
  • PowerCenter and GitHub

    Has anyone used Visual Studio to usr Git and PC?   I need to manage version control using Git. I have done it using Jenkins which supplies a hook to call a Linux Script to do the export, etc and load the XML int...
    John Lyons
    last modified by John Lyons
  • PowerCenter, Git, and Visual Studio

    Has anyone used Visual Studio to usr Git and PC?   I need to manage version control using Git. I have done it using Jenkins which supplies a hook to call a Linux Script to do the export, etc and load the XML int...
    John Lyons
    last modified by John Lyons
  • PowewCenter Support for RHEL 8.x

    Hello Everyone:   IBM-Redhat has moved to the higher version of RHEL and the current 7.8 which is supported by latest Powercenter 10.4.1 is about to move into extended support, which customers are forced to purc...
    user151735
    last modified by user151735
  • Can Informatica 10.4 connect to IBM DB2 11.1 at Database OS SuSe Linux  Enterprise Server 12 SP4

    Can Informatica connect to IBM DB2 11.1 at Database OS  SuSe Linux  Enterprise Server 12 SP4 ?   as per PAM sheet for Informatica 10.4, Informatica support IBM DB2 11.1 at Database OS  SuSe Linux&...
    thamarai kannan
    last modified by thamarai kannan
  • Teradata Timestamp with Timezone Issue in Informatica mapping

    Hello All,   I am creating a mapping where Teradata table is a source and target is a flat file(.csv). I am reading the entire data from the source table (17256447 records). Since the source count is huge, so I...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • PowerCenter 10.5 release date

    Hello   Can someone share the release date of PC 10.5.x and also the PAM.?  I am curious to see if we this supports RHEL 8.x which is very much needed.   Thank you Gurudutt
    user151735
    last modified by user151735
  • Same source and target table to read and update? Can we?

    Hello friends, I have a requirement in such a way that I have to use the target table as source to get the key value and update the same table. The reason being is i need to pull the file date from stage table. Appare...
    Arya Nymeria
    last modified by Arya Nymeria
  • PowerCenter running slow update script

    Hello, we are facing a performance issue reading and writing (update) on SQL Server database. We have installed the Informatica 10.2.0 HotFix 2 on Windows Server 2016. The mapping is a simple pass-through (attached...
    Federico Fanalista
    last modified by Federico Fanalista
  • Parsing xml file in Informatica

    Hi, I am trying to parse an xml file using power center mapping designer and it gives me the following error:   I tried uncommenting the below line in C:\Informatica\10.2.0\server\bin folder and added this as a...
    Mani Ar
    last modified by Mani Ar
  • Connect to PostgreSQL database

    Hello,   I am trying to connect to a PostgreSQL database in Informatica PowerCenter, but there seems to be no option available. I read that I can use ODBC instead but there is only an option "ODBC for Oracle", "...
    inuser474412
    last modified by inuser474412
  • Webservice Provider - Powercenter Fault handling -Target Issue.

    Hi,   I have a webservice mapping which is currently working fine.Now I want to capture the response and any fault code incase of any errors.When I try to add the webservice target to the mapping and link ports ...
    varsha naik
    last modified by varsha naik
  • What's the best approach to read and parse dynamic RSS feed

    Hi,   I have a 7 different RSS feed links (which gets updated once in 5 hours) and I am trying to find the best approach to read contents and process them separately once in 5 hours.   There are few power ...
    Mani Ar
    last modified by Mani Ar
  • Help required in IF ELSE condition

    Hello All,   In an expression transformation, I have 2 ports Ownarea and TargetArea   I want to achieve below scenario   Scenario 1: If Ownarea = 2560 or 0497 or 0498 then { If TargetArea contains...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • Extract the date from Input file and generate output target file as per the extracted date

    Hello All,   Please help. I am extracting the files from 3 different AWS S3 folders/sources inside a same bucket to the local infa_shared unix directory by using below shell script ############################...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • Using Stored Procedure in Power center web service mapping

    Hello All,   I create one procedure in oracle database and trying to use it our web service mapping but it didn't return any result. When i tried to create one to one mapping with oracle type source it ran succ...
    Heena Rajvanshi
    last modified by Heena Rajvanshi
  • Override the value of Persistent Variable

    Hello All,   I have a requirement where I have to generate a .xlsx file appended with Previous day date. (I have generated the .csv file in output and then converted it into .xlsx file via ssconvert utility) H...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • Read AWS S3 files in Informatica PC

    Hello All,   I have a source system which places the .csv files into an AWS S3 bucket inside a folder on a daily basis and this file later on gets archived at some other location after processing. The naming con...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava