• 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • Webservice Provider - Powercenter Fault handling -Target Issue.

    Hi,   I have a webservice mapping which is currently working fine.Now I want to capture the response and any fault code incase of any errors.When I try to add the webservice target to the mapping and link ports ...
    varsha naik
    last modified by varsha naik
  • What's the best approach to read and parse dynamic RSS feed

    Hi,   I have a 7 different RSS feed links (which gets updated once in 5 hours) and I am trying to find the best approach to read contents and process them separately once in 5 hours.   There are few power ...
    Mani Ar
    last modified by Mani Ar
  • Help required in IF ELSE condition

    Hello All,   In an expression transformation, I have 2 ports Ownarea and TargetArea   I want to achieve below scenario   Scenario 1: If Ownarea = 2560 or 0497 or 0498 then { If TargetArea contains...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • Extract the date from Input file and generate output target file as per the extracted date

    Hello All,   Please help. I am extracting the files from 3 different AWS S3 folders/sources inside a same bucket to the local infa_shared unix directory by using below shell script ############################...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • power center

    The infa databases were migrated to new database servers.I've updated the domain to new databases server details  and updated the database properties in admin console.PC_Repo user is used to connect INFA_PC_REPO ...
    swa vall
    last modified by swa vall
  • Handle timeout error as "Not Found"

    Hello All,   We create below web service mapping wrapper mapping and in which we are fetching results by using SOAP API on the basis of user input By SOAP API , we are getting multiple results on the basis on on...
    Heena Rajvanshi
    last modified by Heena Rajvanshi
  • Need to Display multiple records in REST API webservice

    Hello Team,   We need to display multiple records for REST API webservice and callinng this webservice through java code. Please find below screenshot for the mapping and mapplet:   Also attached verbose ...
    Heena Rajvanshi
    last modified by Heena Rajvanshi
  • Repeat the second output column value based on input value

    Hi Guys, I am new to Informatica and trying to implement below scenario in my current project. I am trying to use LPAD, which is not possible as we need to pass specific length for second parameter.   Here is m...
    Venkat G
    last modified by Venkat G
  • Override the value of Persistent Variable

    Hello All,   I have a requirement where I have to generate a .xlsx file appended with Previous day date. (I have generated the .csv file in output and then converted it into .xlsx file via ssconvert utility) H...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • Read AWS S3 files in Informatica PC

    Hello All,   I have a source system which places the .csv files into an AWS S3 bucket inside a folder on a daily basis and this file later on gets archived at some other location after processing. The naming con...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava