• 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
  • Russian character loading issue

    Hello,   We have to load a table with Russian characters from SQL Server to Oracle target. While loading we noticed that the byte length is increasing for russian characters, For example - if the actual length i...
    Arun Kumar
    last modified by Arun Kumar
  • 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
  • Read and write to the same table? 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
  • 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...
    user151735
    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
  • what is the maximum memory usage for the DB(SQLServer) for PowerCenter

    Hello, PowerCenter Users.   what is the maximum memory usage for the DB(SQLServer) for PowerCenter?   My Informatica Arch is here. Informatica Domain Servers { AP1,AP2,AP3 } DataBase Server {DB}:  ...
    Shu Yamamoto
    last modified by Shu Yamamoto
  • 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
  • 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
  • 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
  • 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
  • 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