• Date columns causing table load issues

    Hello,   My source is a flat file with 84 columns out of which there are 6 date columns. The date columns format in source file is YYYY-MM-DD and the values in some of these columns are nulls. The datatype for...
    Vindhya Giri
    last modified by Vindhya Giri
  • PowerCenter Integration Service in Admin Console hangs

    Hello, I have PowerCenter 9.5.0. I'm accessing the Admin Console like so, www.machinename:port/adminconsole. When logging into the Admin Console and under Doman>Services and Nodes, I click the Integration Service.&...
    Michele DuBose
    last modified by Michele DuBose
  • 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
  • Developer Client 10.4.1 is not starting

    I have installed Informatca 10.4.1 and installed developer client. But Developer client is not opening. I have installed jdk 16 also. I have checked metadata logs, below error is showing. Attached metadata logs. Pleas...
    Rajesh Audhivanne
    last modified by Rajesh Audhivanne
  • PowewCenter Support for RHEL 8.x

    Hello Everyone:   IBM-Redhat has moved to the higher version of RHEL and the current 7.8 which is supported by latest Powercenter 10.4.1 is about to move into extended support, which customers are forced to purc...
    last modified by user151735
  • 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
  • Fixed width header, trailer and data

    I have a requirement where I have to create a custom header & trailers (hard code values) in a fixed width file and then the data. Any suggestions please?   Planning to incorporate in one mapping. So In exp...
    Arya Nymeria
    last modified by Arya Nymeria
  • 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
    last modified by user151735
  • Power Center 10.4.1 PPC64 sizing tips

    Hi guys! I'm deploying IPC on AIX, could you please share with me some expertise or maybe there some calculator for sizings? Appreciate it
    Alexander Bartashevich
    last modified by Alexander Bartashevich
  • Informatica performance tuning

    Hello experts,   I'm searching to get some details on Informatica Powercenter real time performance tuning. I'm working in  Informatica for last 2 years but till now I did not get a chance to work with huge...
    Dhiman Dey
    last modified by Dhiman Dey
  • 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...
    last modified by user151735
  • 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
  • Unable to load jackson package

    Hi all I have a java transformation which I'm trying to use to parse a json file. I declare the object "ObjectMapper" and in order to compile it I've added the following .jar libraries in the java tx (settings tab):...
    last modified by user162108
  • 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
  • old mapfwk API does not recognize type "Timestamp"

    Hello,   We have an old Workflow Builder app developed in VBA which uses the mapfwk API in version prior to PWC v9.5. We are currently using PWC v10.2 and PWC v10.4, when generating the Timestamp type is not rec...
    Etienne Aglas
    last modified by Etienne Aglas
  • 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
  • Connect to PostgreSQL database

    Hello,   I am trying to connect to a PostgreSQL database in Informatica PowerCenter, but there seems to be no option available. I read that I can use ODBC instead but there is only an option "ODBC for Oracle", "...
    last modified by inuser474412