• Maria DB table import issue in Powercenter

    Hi all,   Hope everyone is doing well!   I am trying to import Maria DB tables in Powercenter 10.4.1. I've successfully created connection in ODBC Administrator using 'root' username, using Maria DB ODBC 3...
    ASHISH ANANT DESHPANDE
    last modified by ASHISH ANANT DESHPANDE
  • PowerCenter

    Can anyone suggest sql query to find the mappings, session and  command tasks associated with workflow for all project folders in  PC 10.0?
    srini komm
    last modified by srini komm
  • Powercenter 10.5 Client on Windows 7

    Hi. Can the powercenter 10.5 client tools be run on a Windows 7 VM? I have seen some issues reported on v10.2 but there appears to be a workaround using windows compatibility mode. Does this apply to 10.5 as well?
    Des Reilly
    last modified by Des Reilly
  • FATAL Error encountered while importing XML def.

    Hi,   I am trying to create a source definition by importing the client provided XML data file.   But while importing the source definition, I get the following error: I am not the XML expert and not sure ...
    Mani Ar
    last modified by Mani Ar
  • XML Error while reading the file

    Hi,   I am trying to use the following XML to create a source and further read the same file to load my table.   Backyard Tee - Tequila Sunrise - Navy But I am stuck with the following error while readin...
    Mani Ar
    last modified by Mani Ar
  • Latest version of PowerCenter!

    What is the lates verson of PowerCenter for Linux?
    user158493
    last modified by user158493
  • Working with Valid Staged Workflows (WS Hub but Invalid)

    Hello, I have a situation where I have an staged workflow in the WebServices And it is INVALID in the WS Hub but the Workflow is VALID The workflow consist in: 1 session -> multiple sessions (OR CONDITION) But...
    Joao Victor
    last modified by Joao Victor
  • Closing Square Bracket- Informatica - Stored Procedure

    Hi All,   Have tried lot of googling before posting this question here. So please provide your suggestions here   Am calling a T-SQL Stored Procedure from Informatica Power Center thru SQ(SQL Qualifier ) T...
    Jagadish Mohan Gaglani
    last modified by Jagadish Mohan Gaglani
  • Ability to Interface with an API that requires oauth

    Hi,   I am just checking if there is an ability to interface with an API that requires oauth?   Something like sending an authentication request, they respond with a token and we then send another ...
    Mani Ar
    last modified by Mani Ar
  • How to repeat values for multiple rows based on a different port

    Hi,   I have incoming records with many different columns and I want one of the columns to have the same value repeated based on the first row.   Example given below:   In the Input source records, t...
    Mani Ar
    last modified by Mani Ar
  • Post Upgrade Powercenter Performance

    Hi,   We have migrated from PC 9.5.1 on Solaris/Oracle to PC 10.4 on Windows/SQL Server and performance is less that impressive. Looking at the logs of a session would the following show the bottleneck is Inform...
    winsera
    last modified by winsera
  • Mapping variable used in Post SQL Target Property not working

    I've set a value of a mapping variable named $$TotalRecords during a mapping run. For the purpose of this question, the value of $$TotalRecords is 3.  I want to use that variable value as a value in an INSERT sta...
    sdepriest
    last modified by sdepriest
  • 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...
    sdepriest
    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