• Delete records using PowerCenter

    Hi All,   I have simple mapping which extracts data from source and deletes in target. It has composite primary key (composed of 10 columns). This mapping uses only those required 10 columns.   I have not ...
    asagpariya_ciber
    last modified by asagpariya_ciber
  • Read flat file and fail the workflow with an exit code

    Hello Gurus, I am trying to read a file which has three columns. I created a mapping to read and in the second column I can have two values 'P' or 'F'. If I find the value P then exit code is 0 and workflow should be ...
    Arya Nymeria
    last modified by Arya Nymeria
  • How to read multi tagged elements from XML Source

    Hi,   I have the following XML source file (I just put a portion of my XML source file here and not the entire content due to size).   I have created my denormalized XML source using the raw XML file and ...
    Mani Ar
    last modified by Mani Ar
  • Mapping and Workflow documentation

    Is there an easy way to export mappings and workflow into a documentation type form of document?  I saw a link to Marketplace but doesn't work.  I also understood I could "export metadata" to Excel but I do ...
    Dianna Gibbs
    last modified by Dianna Gibbs
  • Informatica SQL Transformation multiple queries

    Hi everyone,   I have a requirement to use oracle sequence next val to generate sequence at database.   I have a mapping which is loading 3 separate tables using expression. However all 3 target tables ha...
    Meet Patel
    last modified by Meet Patel
  • Mappings and workflows transfer   from Informatica PC 9.5.1 to 10.5

    We are planing to update IPC 9.5.1 to 10.5. Is it necessary to make only consistently installing updates (9.5.1 => 10.1.1. => 10.5) ?  Or will  I  can  just install IPC 10.5 and use IPC clien...
    Andrei Bukhavetski
    last modified by Andrei Bukhavetski
  • 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
  • I get some problems with deploying PWC on Kubernetes

    Hi everyone,   My PWC version is 10.4.1 and I want to deploy it on my RHEL 7.8, but I got some problems. I list my steps following:   1. I download informatica_container_utility_linux-x64.zip and unzip it...
    Cyril Wu
    last modified by Cyril Wu
  • Http Transformation authorization

    Hi All,   Can any one guide on setting up the authorization for http transformation. The actual requirement is to authorize using bearer token to fetch data from Rest API and I am new to this area. But I saw som...
    Gayathri Nataraj
    last modified by Gayathri Nataraj
  • PowerCenter Integration Service in Admin Console hangs

    Hello, I have PowerCenter 9.5.0. I'm accessing the Admin Console like so, www.machinename:port/adminconsole. When logging into the Admin Console and under Doman>Services and Nodes, I click the Integration Service.&...
    Michele DuBose
    last modified by Michele DuBose
  • Primary Key change and SCD Type 2

    Hello Gurus,   I have a dimension table with surrogate key as the primary key. Employee_identifier is the key which is used to lookup and maintain SCD Type 2 history in the table. Employee_identifer is a 7-digit...
    Divya Karun
    last modified by Divya Karun
  • 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
  • PMCMD can't run

    Hi All       I meet an issue and need help . Now I need use pmcmd to run workflow, but when try to run pmcmd ,it failed to start pmcmd.  Not sure what happened.   system : Windows ...
    Wenyuan Du
    last modified by Wenyuan Du
  • 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
  • is DAC 11.1.1.6.4 compatible with Informatica 10.4 ?

    is DAC 11.1.1.6.4 compatible with Informatica 10.4 ?   i am not able to find in PAM sheet, please help how to validate with Informatica vendor and ensure DAC 11.1.1.6.4 supported by Informatica 10.4   DAC ...
    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
  • 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