• Impala table Error by using powercenter through Impala ODBC connection

    My requirement is to pull data from Hive tables and dump it into the Impala table using powercenter ODBC Connection. I am using Imapala  ODBC connection to write to target table. This is simple one to one mappi...
    Salman Khan
    last modified by Salman Khan
  • Primary Key change and SCD Type 2

    Hello Gurus,   I have a dimension table with surrogate key as the primary key. Employee_identifier is the key which is used to lookup and maintain SCD Type 2 history in the table. Employee_identifer is a 7-digit...
    Divya Karun
    last modified by Divya Karun
  • How to: Read an XML file from a network drive?

      Please forgive me for such a noobie question, my company has tasked me with doing some work with PowerCenter and I have not yet been to training. I've designed a workflow that will take an XML input source and...
    michael.griffith
    last modified by michael.griffith
  • DBConnection impact when used in Application Connection type. PC10.2HF1 to PC10.4.1 or PC10.5

    Hello Everyone,   We are in the process of upgrade from 10.2HF1 to 10.4.1 or 10.5.  I came across an issue with the Application connectors with 10.4.1 where the standard or DBConnection*** does not support ...
    user151735
    last modified by user151735
  • Can Informatica 10.4 connect to IBM DB2 11.1 at Database OS SuSe Linux  Enterprise Server 12 SP4

    Can Informatica connect to IBM DB2 11.1 at Database OS  SuSe Linux  Enterprise Server 12 SP4 ?   as per PAM sheet for Informatica 10.4, Informatica support IBM DB2 11.1 at Database OS  SuSe Linux&...
    thamarai kannan
    last modified by thamarai kannan
  • Teradata Timestamp with Timezone Issue in Informatica mapping

    Hello All,   I am creating a mapping where Teradata table is a source and target is a flat file(.csv). I am reading the entire data from the source table (17256447 records). Since the source count is huge, so I...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • Web Service POST request with HTTP Transformation

    Hello GURUs   I'm trying to configure an http transformation in order to load data to a web service using POST method. The webservice provider has gave me a json sample to make me build the ws request. It is ve...
    user162108
    last modified by user162108
  • Changing the default session config

    If I change log options in the default session config. Do I then need to check-out, save, and check-in all the workflows that use that default session config, or will the workflows just pick on the changes automatical...
    Ken Skinner
    last modified by Ken Skinner
  • PowerCenter 10.5 release date

    Hello   Can someone share the release date of PC 10.5.x and also the PAM.?  I am curious to see if we this supports RHEL 8.x which is very much needed.   Thank you Gurudutt
    user151735
    last modified by user151735
  • Shell Script to move files from Infa_shared directory to another server

    Hello All,   ######## I want to achieve this via Shell Scripting ########   I have a requirement to move a file(which will come on a daily basis) in unix box location (data/infa_shared/SrcFiles/ABC/). The ...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • How to handle comma and double quotes in data for a .csv output file

    Hello All,   For my requirement, Source is a Hive database and Target is flat file(in .csv format). Now I want to handle both comma , and double qoutes “ and newline as well   Below is the sample dat...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • Powewcenter Yellowbrick Migration

    All,   We are in the process of migrating Netezza appliance to Yellowbrick on cloud towards end of this year. Has anyone started this migration or planning to do so.  Please share you thoughts and experienc...
    user151735
    last modified by user151735
  • Requirement to get the cookie values like AWSALB from Http Transformation

    Hi,   i too have requirement to get the cookie value from Http Transformation in Power center.   As of now i am able to get the ASP.NET_SessionId from HTTP_OUT. But i also need AWSALB from cookie.   ASP...
    Rajesh Ananthakrishnan
    last modified by Rajesh Ananthakrishnan
  • PowerCenter running slow update script

    Hello, we are facing a performance issue reading and writing (update) on SQL Server database. We have installed the Informatica 10.2.0 HotFix 2 on Windows Server 2016. The mapping is a simple pass-through (attached...
    Federico Fanalista
    last modified by Federico Fanalista
  • Metrics

    I'm trying to fill out a form for Informatica Cloud Data estimate.In that they are asking about No of jobs, mbs and % .   Can anyone suggest how can we determine mbs and % in PowerCenter 10.0?
    srini komm
    last modified by srini komm
  • Creating mapping for calling the oracle Stored Procedure Dynamically

    Hello,   I am trying to create a Informatica mapping where in the Source Qualifier "PRE" or "POST" SQL, I want to call a Oracle Stored procedure with parameters Dynamically. Below is the more detailed Requireme...
    Aravindh Narasimhabahu
    last modified by Aravindh Narasimhabahu
  • Wf Scheduled to run 10 times Monday to Friday

    Hi Team,   I need to run the Wf 10 times every day from Monday to Friday, i have set the bellow properties and wf was running on the day it was scheduled but not scheduling for the next dates. using informatica...
    SP K
    last modified by SP K
  • Indirect Load

    Hello,   I have requirement to load 6 flat files into the target table which are of same structure. I know, we can achieve this by using indirect load option.   But I wanted to know what are the best prac...
    Dhiman Dey
    last modified by Dhiman Dey
  • Parsing xml file in Informatica

    Hi, I am trying to parse an xml file using power center mapping designer and it gives me the following error:   I tried uncommenting the below line in C:\Informatica\10.2.0\server\bin folder and added this as a...
    Mani Ar
    last modified by Mani Ar
  • Links to Target missing while importing the mapping

    Hi All,   I am trying to importing mapping which consists of shared objects (source/target). I imported the shared objects first and when i tried to import the mapping,mapping getting imported but the links to ...
    Krazy king
    last modified by Krazy king