• Relational Connection cannot link to Azure DB2 server

    We have set up a DB2 server on Azure and link it to PowerCenter 10.5 Standard Edition. Under Designer we use 'DataDirect 7.1 DB2 Wire Protocol' under ODBC connection and can import table schema on DB2 database. Under ...
    Eugene Chen
    last modified by Eugene Chen
  • SAP BCI Extractor

    could you please share the SAPNWRFC lib for SAP BCI extraction which supports Informatica Power center 10.5
    Dilip Sabbineni
    last modified by Dilip Sabbineni
  • Working day table to control the execution of PowerCenter Workflow

    We have a wf_DAILY workflow in PowerCenter Standard Edition 10.5 to be scheduled to execute on 01:00 every day after the daily batch. However, we want this workflow wf_DAILY to be called every day but checking the WOR...
    Eugene Chen
    last modified by Eugene Chen
  • Fetching values from group of rows

    Hi All   I have a table with following format with Col B as key. For group of values in Col B, if the col A has code as 'ABC', then that record has to be treated as Master record and rest of the records of that ...
    Kamal Haria
    last modified by Kamal Haria
  • File Creation in Informatica

    Hi Team,            I would like to create a target file as zip file, now I am using output file type as command and creating the zip file. But after unzipping the fi...
    Arjun Biradar
    last modified by Arjun Biradar
  • REG_EXTRACT data from second set of parentheses (if exists)

    Hello,   I am splitting a location field into 2 fields (location and location code).   The format of the field is something like USA (USA1); so USA -> location, USA1 -> location_code.   For loc...
    Bobby Price
    last modified by Bobby Price
  • Web Service Consumer - WSSE Security Header Timestamp TimeToLive

    Does anyone know if PowerCenter's Web Service Consumer (WSC) transformation can be configured to add the Timestamp Created/Expired values to the WSSE Security Header (bolded in the example below)?   A SOAP serv...
    last modified by sdepriest
  • How to Configure Hive ODBC Connector for Cloudera Enterprise with PowerCenter on Linux - new article from the Informatica doc team

    Abstract You can configure Hive ODBC Connector for Cloudera Enterprise with PowerCenter® on Linux. This article describes how to install and configure the connector and also use the connector with the PowerCente...
    Sujitha Alexander
    last modified by Sujitha Alexander
  • Creating PostgreSQL source/target definitions manually

    We just upgraded Informatica PowerCenter to 10.4.1 and enabled the postgresql plugin. Now I can create PostgreSQL connections but I don't know how to create source/target definitions without using the "PowerExchange ...
    Ali Z
    last modified by Ali Z
  • Disable (and restore!) ports in Lookup transformation

    5 votes
    Option to automatically remove unused ports in a mapping (or  even across several mappings). This is known to speed up a mapping, but  is easily forgotten during design. Lookup boxes should have a  way...
    created by EC63730
  • How to get date from Table A when we do Table B minus Table A

    Hello, I am stuck at a point where I am not able to move forward. I am trying to find records that exists in Table B but not in Table A which is easy but the caveat is that I need a column in Table A that I need to us...
    Arya Nymeria
    last modified by Arya Nymeria
  • Rest API Call with Bearer Authorization - Power Center

    Hello All,   We are trying to implement a solution to get data from Rest API call. Would you please suggest or recommend a process using informatica Power Center how can we pass the bearer Authentication token...
    Gaurav Lohiya
    last modified by Gaurav Lohiya
  • Data to parameter flat file by shifting to new line

    Hello, I am trying to achieve to write the [GLOBAL_SAHRED]  as first line and date to the second line in a flat file in a single mapping. I am using dummy oracle as source and trying to create the output port and...
    Arya Nymeria
    last modified by Arya Nymeria
  • 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 ...
    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
  • 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
  • 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
  • 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
  • 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