• Repository Query to get all SOurce & target connections including source & target flat file

    Hi,   I was able to get hold lots of repository query to get a list of source and target DB connections but what i also require is a list that provides me any type of connections and their values - Ex: IF I have...
    vishwakumar Palamadai
    last modified by vishwakumar Palamadai
  • Informatica Upgrade from 9.0.1

    I want to upgrade from Informatica 9.0.1 to 10.2 and I Installed windows 2012 R2 initially and copied previous version folder to new machine for upgrade.When I start the installation of Informatica 9.5.1 this gives er...
    Ashish Pandit
    last modified by Ashish Pandit
  • RunAjobCli using Powershell

    Hi,   I want to run one of our taskflow continuously until I finish  all the files in a windows folder. This task can process only one file at a time. Currently i am running this task using 5 mnt infomatica...
    Shabeer Madathil
    last modified by Shabeer Madathil
  • REP_SESS_TBL_LOG Dups rows

    Hi Masters,   I have a mapping which is loading 3 tables. I was looking to check the metadata information of this mapping's session like success rows, failed rows etc. I thought that this information can be fetc...
    Mohit Verma
    last modified by Mohit Verma
  • SCD TYPE-1 WITHOUT LOOK UP TRANFORMATION

    Hi HOW TO DO SCD TYPE -1 BY USING JOINER TRANSFORMATION? EXPLAIN ME   THANK YOU.
    Ajay .
    created by Ajay .
  • Connet to MSSQL Server with Windows Authentication

    Hello I'm trying to connect some services to MSSQL Server with Windows Authentication without any success. Only Domain and PowerCenter Repository show me the option "Trusted Connection", in this case I'm able to ins...
    Federico Fanalista
    last modified by Federico Fanalista
  • HOW TO GET THIS?

    SOURCE TABLE   ID NAME 10 RAJA 10 KIRAN 20 SREENU 20 VIJAY 10 AKASH 20 TEJA 30 RAJU   TARGET TABLE       ID NAME 10 RAJA,KIRAN,AKASH 20 SREENU,VIJAY,TEJA 30 RAJU       TELL...
    Ajay .
    last modified by Ajay .
  • How can I choose selected pipeline in mapping for debugger

    Hi All,   I'm using debugger for a mapping which has 2 pipelines, in 1st pipeline i almost have 8 lakh records, but i want to check the data for 2nd pipeline , so how can i skip the 1st pipeline and choose the 2...
    Karthik G
    last modified by Karthik G
  • Informatica support case

    Hi,   I need to open a case with informatica support team. Could you please help me out with the process? Help will be appreciated.   Thankyou !
    swetha moorthy
    last modified by swetha moorthy
  • ERROR: Connect failed: SAP error message [===> SAPReader: Connect Failed.  Error in network & communications.  key = RFC_COMMUNICATION_FAILURE  message =   ERROR service 'sapmsTSR' unknown

    Hi All,   Can anyone please tell me why the below error occurs ?     ERROR: Connect failed: SAP error message [===> SAPReader: Connect Failed. Error in network & communications. key = RFC_CO...
    swetha moorthy
    last modified by swetha moorthy
  • Download links for Informatica Client 10.2

    Hi,   I'm working on a POF using the Informatica PowerCenter PAYG from the AWS marketplace.   Can someone tell me where to get download links for the Informatica Client to use with this please.   Tha...
    Mark Baker-Munton
    last modified by Mark Baker-Munton
  • Log Info generated from Informatica PowerCenter

    Could you please tell, why do we use below logs & what kind of information would be stored in each log.   exceptions.log catalina.out node.log node_jsf.log ispLogs.log
    Kittu Babu
    last modified by Kittu Babu
  • Is it possible to connect our Informatica PowerCenter to Salesforce using certificate instead of user/password?

    Hi,   We would like to know if it is at all possible to connect our Informatica PowerCenter to Salesforce using certificate instead of user/password which we are using today? When we looked around we only found ...
    Jester Tolentino
    created by Jester Tolentino
  • The Service P00_DIS could not be enabled due to the following error:  [DOM_10054]

    Hi   We want to use Informatica Analyst a little more at NAV. In that regard, I have discovered that it is a mistake to start a dependent service, Data Integration Service.   When I try to start the servic...
    Jester Tolentino
    last modified by Jester Tolentino
  • Session & Workflow log creation through pmcmd command

    Hi Frnds,   My requirement is that I am trying to generate session log and workflow log through pmcmd commands using one shell script and finally displaying the same on Autosys screen because as a part of a deve...
    mini mishra
    last modified by mini mishra
  • JDBC support for connections to Oracle sources and targets in Powercenter

    Hi,   Our database administrators recommend the use of Oracle's Universal Connection Pool (UCP) to manage connections between clients and Oracle Exadata. UCP is not only recommended for load balancing qualities...
    Jester Tolentino
    last modified by Jester Tolentino
  • PowerCenter OS profile with different OS (Linux) user

    We created a new Informatica OS profile using a different OS (Linux) user other than the one used for running the Informatica service. The workflows are failing with VAR_27098 error, ERROR: Error in expanding variab...
    Sameer Deshpande
    last modified by Sameer Deshpande
  • DTM Buffer issue

    We just did an upgrade from Powercenter 9.5.1 to 9.6.1 Hotfix 2. We are beginning to see the following error: Message Code: DBG_21699 Message: The reader is waiting for the DTM to provide buffer blocks. To improve ...
    lenixj
    last modified by lenixj
  • Problem Installing INFA PowerCenter

    Hi           We are trying to upgrade our old Informatica server from version 9.0.1 to 9.5.1. During both upgrade and installation, we also tried a fresh install instead of an ...
    Jester Tolentino
    last modified by Jester Tolentino
  • Dynamic mapping with flatfiles

    Hi All , We are trying to create a BDM mapping (10.2 version) where different flat file data objects (varying number of columns) need to be parameterized and for each flat file data object the source file name & ...
    inuser481045
    last modified by inuser481045