• 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
  • is DAC 11.1.1.6.4 compatible with Informatica 10.4 ?

    is DAC 11.1.1.6.4 compatible with Informatica 10.4 ?   i am not able to find in PAM sheet, please help how to validate with Informatica vendor and ensure DAC 11.1.1.6.4 supported by Informatica 10.4   DAC ...
    thamarai kannan
    last modified by thamarai kannan
  • 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
  • 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
  • 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
  • Error connection PWC to Simba ODBC BigQuery

    Hi,   Information our plataform:    Plataform PWC 10.2.0 HF2    Unix Suse 12 SP5 (Server PWC)   When we try connect session with BigQuery for ODBC (Simba) make this error. " Source ...
    Oliver Mosquera
    last modified by Oliver Mosquera
  • 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", "...
    inuser474412
    last modified by inuser474412
  • Integration between PowerCenter and Tableau

    Hi Team,   Is it possible to integrate PowerCenter and Tableau? Is there any tableau connector/plugin/connector that Informatica has got? If so, is there any steps / documentation could be shared please?   ...
    inuser526279
    last modified by inuser526279
  • 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
  • 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
  • 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
  • Database driver error

    I get the below error when I run the mapping to load data from a flatfile into the database. Can anyone help? I am using Oracle 11g and informatica 10.2       WRT_8001 [Session ff_DB Username hr DB Err...
    Gouthami Pasham
    last modified by Gouthami Pasham
  • 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
  • Read the latest .csv file from AWS S3 bucket

    Hello All,   There is a bucket/folder in AWS S3 where .csv files comes on a daily basis. The naming convention of a .csv file is 2001DBBYLAST-YYYYMMDDHHMISSSSS.csv   This .csv file contains a dot.(Eg: Seri...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava