• Powerenter -Mapping in read only mode

    How to open a mapping in read only mode ?
    last modified by informatica9.sam
  • Unable Bring up Informatica service

    I am trying to bring up the informatica service but am getting below error   Node.log 2019-11-29 05:20:36,564 ERROR [Monitor Guaranteed Message Logger Thread] [CCM_10322] While logging messages to the Log Servic...
    last modified by SENTHUR KANI V R
  • Informatica Mapping Now much Slower

    I have a mapping that ran pretty fast up until today. Seemingly now when I execute it, it runs the mapping for an unlimited amount of time. Can anyone explain why my mapping would either randomly stop working or incur...
    Jacob Bardwell
    last modified by Jacob Bardwell
  • Feasibilty analysis of data transformation using any ETL tool

    I don't have any experience on any ETL tool. However I want to know if it is possible to do the followings using any ETL tool or we need to write a java or any other batch job to do this:    Scenario 1: Th...
    Sumit Pal
    last modified by Sumit Pal
  • Informatica Power Center 9.5.1 - Workday Connectivity

    Can we connect to workday using Informatica power center 9.5.1 and using http transformation. When we are trying to connect using http transformation calling a https url of workday, we get below error -   Messag...
    last modified by speecha108
  • 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
  • How to set up Boolean logic using multiple columns?

    I am wanting to create this new column which is a boolean. It will return a "Y" if the conditions are true and an "N" otherwise.   A condition is true depending on certain columns:   Date_column has to be ...
    Thomas Stevens
    last modified by Thomas Stevens
  • Informatica admin activities?

    Hi,   I'm new to informatica admin. What are the tasks needs to be taking care by admin? Could you explain on this?   Thanks, Sankar
    last modified by sankarapandiyan
  • Generate all possible combinations of values in a column

    My source table looks like:   Col_1 Col_2 1 F 2 S 3 A   I want to generate a target that has all possible combinations of values from column Col_2 and add a surrogate key. The target should be like: SK Comb...
    Anand Rajakrishnan
    last modified by Anand Rajakrishnan
  • Sequence generator is passing null

    Hi All,   In my mapping I have a sequence generator which passes the nextvalue to 3 different targets via an expression transformation. But I can see the value in only 2 targets(table) and in one more target ( ...
    Vidya M C
    last modified by Vidya M C
  • Storing the Source and Target record count

    Hi,   I designed an informatica mapping which will extract the data from .txt file and load into oracle table. This process is working as per the expected.   I would also like to know and store how many re...
    john S
    last modified by john S
  • Why the Integration service goes down frequently?

    Hi,   Powercenter Integration service goes down frequently. and below is the error message I get every time.   Same error was available in node.log as well.         Powercenter GRID ...
    Vidya M C
    last modified by Vidya M C
  • The infacmd getSessionLog command does not work when a PowerCenter session is in a worklet when coupled with workflow Run ID parameter

    HI Team,   Getsession log for an worklet works fine if we ignore the worklow run id or instance name parameter.   infacmd.sh getSessionLog -dn name_of_domain -is integration_service_name-rs repository_name...
  • Unable Edit Source Field Types in Mapping Task

    Multiple files are to be loaded into their respective tables . Both files & tables have same schema/format, only file/table names are diff. Each field inside has same name,ordinal position & data types. Used I...
    Himanshu P
    last modified by Himanshu P
  • Valid XML source not read because tag missing

    Hello,   I have a weird problem. I developed a mapping that reads data from an xml file and inserts it in a flat file. My mapping works well but when I remove a specific tag, the mapping doesn't generate the f...
    Hugo ROCHE
    last modified by Hugo ROCHE
  • How to dynamically change the Informatica connection attribute?

    Hello Folks, Could someone help me with the below requirement? The naming convention of our SQL server DBs are <DB_Name>_<Current_Date>. We have a rule defined at DB level to automatically create a repl...
    last modified by BharathB
  • Data being truncated

    Hello,   Some data is being truncated (warning FR_3015) in my reader. But I've checked and I'm sure of the datatypes I've specified (string 14). I've checked the whole mapping for precision issues but I can't fi...
    Hugo ROCHE
    last modified by Hugo ROCHE
  • Help in webservice Consumer transformation

    Hi All,   I need one help regarding Web service consumer transformation my requirement is as below I have to consume two web service(SOAP) the first one will give the token as output and that token i need to...
    mayur marathe
    created by mayur marathe
  • Need guidance with PowerCenter DI Developer Specialist Certification

    Eva/Niraj/All, I am working on Informatica 9.5.1 at work and interested in pursuing Informatica Developer Certifications. Can you please guide me on the following related to PowerCenter DI Developer specialist certif...
  • Disaster Recovery Environment Configuration without HA

    Hi All , Currently we have Informatica Production Environment which is already live and we are planning to have the DR set up now.   https://network.informatica.com/message/13604#13604 I am planning to have t...
    siva krishna
    last modified by siva krishna