• 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
  • Mappings and workflows transfer   from Informatica PC 9.5.1 to 10.5

    We are planing to update IPC 9.5.1 to 10.5. Is it necessary to make only consistently installing updates (9.5.1 => 10.1.1. => 10.5) ?  Or will  I  can  just install IPC 10.5 and use IPC clien...
    Andrei Bukhavetski
    last modified by Andrei Bukhavetski
  • 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
  • IICS Primer for PowerCenter Developers

    For years, Informatica PowerCenter has been the gold standard for on-premises data integration. For many companies and organizations Informatica PowerCenter, together with an enterprise data warehouse, has served as t...
    Rashmi Rekha Gogoi
    last modified by Rashmi Rekha Gogoi
  • 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
  • Does Informatica PC 10.5 support Oracle 18C Express Edition as Repository DB?

    Does Informatica PC 10.5 support Oracle 18C Express Edition as Repository DB?
    Andrei Bukhavetski
    last modified by Andrei Bukhavetski
  • 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
  • Informatica and Sql Server compatibility ?

    Hi Team,   I have a specific issue which some time causing data duplicate and no duplicates in source. I am getting duplicates in Tgt DIM tables, Duplicates records are inserting only when we get Update on acti...
    SP K
    last modified by SP K
  • Power Center 10.4.1

    Hi,   We are trying to Upgrade our Informatica Version from 9.5 to 10.4 , for few workflows in 9.5  we have SQL Server 2005 Source would  10.4 Support SQL Server 2005.   Thanks, Anurag
    Anurag Pedditi
    last modified by Anurag Pedditi
  • 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
  • domain configuration error for 10.4

    Hi All,   I am trying to install informatica 10.4 on Linux manchine (OS: Redhat 7 & Database: Oracle 11g), while installation I am getting below. Can someone please help me to fix this issue.   Definin...
    Gowtham Kamle
    last modified by Gowtham Kamle
  • user_powercenter_repo still trying to log in to old server after switching to new server

    Hi all experts,   Recently we moved repository server to a new one. we only have one node in this domain. We used infasetup.bat updategatewaynode and successfully updated the node. On informatica admin console, ...
    Kathy Wang
    last modified by Kathy Wang
  • 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
  • Cloud solution for PowerCenter

    Hello Guys,   I have two below questions , 1. Does Informtica provides cloud hosted solution for PowerCenter? 2. I believe we can install it on any cloud vendor as standalone application over VMs? AWS/Azure/OC...
    Divyam Malviya
    last modified by Divyam Malviya
  • 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