• 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
  • REG_MATCH expression

    Hello All,   My requirement for Target_Field_A is as follows: If Source_Field_A like ‘%ORGIN%’ then set ORIGIN,   Else if Source_Field_A like ‘%DEST%, then set DESTINATION.  ...
    Divya Karun
    last modified by Divya Karun
  • Mapping and Workflow documentation

    Is there an easy way to export mappings and workflow into a documentation type form of document?  I saw a link to Marketplace but doesn't work.  I also understood I could "export metadata" to Excel but I do ...
    Dianna Gibbs
    last modified by Dianna Gibbs
  • 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
  • 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
  • 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...
    user151735
    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
  • 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
  • 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
  • Find whole number and decimal and pad zeros.

    Gurus, for a given whole number or decimal I need to pad '00' to right and remaining zeros to left if the length is less than 12. For example if the number is 123 then  000000012300. Similarly for decimals if i h...
    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
    user151735
    last modified by user151735
  • Same source and target table to read and update? Can we?

    Hello friends, I have a requirement in such a way that I have to use the target table as source to get the key value and update the same table. The reason being is i need to pull the file date from stage table. Appare...
    Arya Nymeria
    last modified by Arya Nymeria
  • 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
  • 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
  • Please help scenario

    I have a requirement to identify the records in history table that doesn't exist in stage table. The caveat is that I need to use the file date from the stage table to use as deactivation date and update history table...
    Arya Nymeria
    last modified by Arya Nymeria
  • 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