• PowerCenter

    Can anyone suggest sql query to find the mappings, session and  command tasks associated with workflow for all project folders in  PC 10.0?
    srini komm
    last modified by srini komm
  • FATAL Error encountered while importing XML def.

    Hi,   I am trying to create a source definition by importing the client provided XML data file.   But while importing the source definition, I get the following error: I am not the XML expert and not sure ...
    Mani Ar
    last modified by Mani Ar
  • XML Error while reading the file

    Hi,   I am trying to use the following XML to create a source and further read the same file to load my table.   Backyard Tee - Tequila Sunrise - Navy But I am stuck with the following error while readin...
    Mani Ar
    last modified by Mani Ar
  • How to get a specific record which is failed due to a WebServices Consumer Transformation time-out error

    Hello All, I have a mapping where the source is Oracle db. 1. Does informatica processes all the records from source sequentially or in parallel ? 2. I have a mapping where the source records pass through a mappin...
    Prasanna Ramachandran
    last modified by Prasanna Ramachandran
  • How to repeat values for multiple rows based on a different port

    Hi,   I have incoming records with many different columns and I want one of the columns to have the same value repeated based on the first row.   Example given below:   In the Input source records, t...
    Mani Ar
    last modified by Mani Ar
  • Get MAX values on Pushdow optimization

    Hi   I've already asked a very similar question but now I'm testing Pushdow optimization.   This is my source  (TABLE) product    Line   Order     Toto q...
    Rudi Ribere
    last modified by Rudi Ribere
  • Fetching values from group of rows

    Hi All   I have a table with following format with Col B as key. For group of values in Col B, if the col A has code as 'ABC', then that record has to be treated as Master record and rest of the records of that ...
    Kamal Haria
    last modified by Kamal Haria
  • REG_EXTRACT data from second set of parentheses (if exists)

    Hello,   I am splitting a location field into 2 fields (location and location code).   The format of the field is something like USA (USA1); so USA -> location, USA1 -> location_code.   For loc...
    Bobby Price
    last modified by Bobby Price
  • How to get date from Table A when we do Table B minus Table A

    Hello, I am stuck at a point where I am not able to move forward. I am trying to find records that exists in Table B but not in Table A which is easy but the caveat is that I need a column in Table A that I need to us...
    Arya Nymeria
    last modified by Arya Nymeria
  • Rest API Call with Bearer Authorization - Power Center

    Hello All,   We are trying to implement a solution to get data from Rest API call. Would you please suggest or recommend a process using informatica Power Center how can we pass the bearer Authentication token...
    Gaurav Lohiya
    last modified by Gaurav Lohiya
  • Data to parameter flat file by shifting to new line

    Hello, I am trying to achieve to write the [GLOBAL_SAHRED]  as first line and date to the second line in a flat file in a single mapping. I am using dummy oracle as source and trying to create the output port and...
    Arya Nymeria
    last modified by Arya Nymeria
  • Read flat file and fail the workflow with an exit code

    Hello Gurus, I am trying to read a file which has three columns. I created a mapping to read and in the second column I can have two values 'P' or 'F'. If I find the value P then exit code is 0 and workflow should be ...
    Arya Nymeria
    last modified by Arya Nymeria
  • XML generator Transformation invalid

    Hello All,     I create one xsd file in which we have so many one-many relationship. I create xml generator and it successfully created as per the requirements. COnnected some input ports whcih are required...
    Heena Rajvanshi
    last modified by Heena Rajvanshi
  • 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
  • How to read multi tagged elements from XML Source

    Hi,   I have the following XML source file (I just put a portion of my XML source file here and not the entire content due to size).   I have created my denormalized XML source using the raw XML file and ...
    Mani Ar
    last modified by Mani Ar
  • 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
  • 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
  • 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
  • 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