• informatica scheduler

    How do i schedule a workflow to run every wednesday of the week and 1st of every month through informatica scheduler?
    Madura Nattudurai
    last modified by Madura Nattudurai
  • In Place OS and DB upgrade in Informatica 10.4.1

    Dear Team,   We have Informatica power center 10.4.1 installed in Windows OS 2012R2 and with repository database is Microsoft SQL DB 2014. Now, client requirement is to Upgrade windows OS to 2019 and Microsoft S...
    Thiru Murugan U
    last modified by Thiru Murugan U
  • Java Version for In Place Informatica upgrade

    Dear Team,   We are planning for Informatica upgrade from Informatica PowerCenter 9.6.1. If we are going in the path   Informatica 9.6.1 > install HF4 -> Informatica 10.2 -> Informatica 10.4 ...
    Thiru Murugan U
    last modified by Thiru Murugan U
  • 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
  • Hanging Sessions?

    The domain crashed and I restarted w/o an issue.  But several processes seemed to be restarted for sessions, which I am assuming were running when the crashed occurred. They have no impact, but they are listed wh...
    John Lyons
    last modified by John Lyons
  • Java Settings for PowerCenter

    We are using PoweCenter v10.2 on Unix/Oracle.   We reached the CPU usage limit, and PC would crash.  Running with multiple threads, etc would cause this.   We are planning to increate the number of CP...
    John Lyons
    last modified by John Lyons
  • 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
  • Post Powercenter Upgrade Performance Issues

    Hi, We have upgraded from PC 9.5.1 on Solaris/Oracle to PC 10.4 on Windows/SQL Server. Performance is less than impressive and I need some help understanding the sessions logs. On Solaris we see stats from a session...
    winsera
    last modified by winsera
  • Informatica 9.6.1 to Informatica 9.6.1 HF4

    Dear Team,   We have Informatica power center 9.6.1 in Windows OS 2012. We are planning to apply Informatica hot fix version. From - Informatica 9.6.1          ...
    Thiru Murugan U
    last modified by Thiru Murugan U
  • How to get a specific record which is failed due to a WebServices Consumer Transformation time-out error

    Hello All, I have a mapping where the source is Oracle db. 1. Does informatica processes all the records from source sequentially or in parallel ? 2. I have a mapping where the source records pass through a mappin...
    Prasanna Ramachandran
    last modified by Prasanna Ramachandran
  • 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
  • Way to get worklet param values from repo

    Hi! Trying to sql-query my informatica powercenter 10.1.1 repository to get worklet parameter values. I can see those parameters in log files but can't find them in the repository. Is there any way to achieve my goal?
    Alexander Shakhov
    last modified by Alexander Shakhov
  • 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
  • Http Transformation is failing when connecting with service  for xml input

    Hi All,   I am calling a service  by passing input as xml. along with that i am passing client id, client secret and backend url.   if the number of rows form input is less than 130, the job is comple...
    VIJAYAKUMAR PONNUSAMY
    last modified by VIJAYAKUMAR PONNUSAMY
  • 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