• 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
  • Using Stored Procedure in Power center web service mapping

    Hello All,   I create one procedure in oracle database and trying to use it our web service mapping but it didn't return any result. When i tried to create one to one mapping with oracle type source it ran succ...
    Heena Rajvanshi
    last modified by Heena Rajvanshi
  • 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
  • LIKE Clause in Expression transformation

    Hello All,   I have a requirement where in I have to check for below condition(Provided by business) upper(UniBody/Frame Damage)=’YES’ OR upper(Operable)=’NO’ OR TRIM(TRIM(REGEXP_REPLA...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • Flat files with different multiple headers and footers

    I have flat file in the below format with multiple headers and footers and I need to Mask/De-identify random columns.   H Col1 Col2 Col3 Col5 D XX1 XX2 XX1 F 000001 H Col2 Col1 Col3 Col4 D XX1 XX2 XX2 D XX1...
    Subrahmanyam Yenumala
    last modified by Subrahmanyam Yenumala
  • Convert Excel data into a .txt file having tilda ~ as a separator

    Hello All,   I am getting data in an Excel spreadsheet(.xlsx format) as below   My requirement is that I need to convert this data into a .txt file having tilda(~) as a separator as below   FEATURE...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • Power center Administration

    how to get the certification on Power Center Administration.
    Venkata Sudhakar Goli
    last modified by Venkata Sudhakar Goli
  • Can we call runnable jar using Java transformation in Powercenter?

    Hi ,   I have java jar which works fine if i run it using script but i would like to call using transformation (like Java or Custom) . And java jar and syntax looks like below.   java -classpath /usr/loca...
    Santosh AB
    last modified by Santosh AB
  • unable to fetch log [CORE_003][CORE-003] An internal Exception Occured with message [LGS_10052][LGS_10052] The Log Service has no record of the requested session or workflow run.\n

      i got following error when i ran the workflow informatica9 version and sesssion task got failed. unable to fetch log [CORE_003][CORE-003] An internal Exception Occured with message [LGS_10052][LGS_10052] ...
    EC104367
    last modified by EC104367
  • How to remove single last byte zero from String in Informatica

    Hi All,   I want to remove last byte zero from given string in Informatica. Could you please assist ?   Example -   '1636600' needs to be converted as '163660' '637410' needs to be converted as '63...
    Shashikant Gagare
    last modified by Shashikant Gagare
  • How to return a part of a column data from an unconnected Lookup?

    I have an unconnected lookup as below Column PRIMARY_KEY is an input port and its value is being passed from another expression transformation as this :LKP.LKP_C_BO_DLCT_XREF(i_PRIMARY_KEY) This PRIMARY_KEY column...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • Posting a JSON File to a REST API using Informatica PowerCenter

    I am give a REST API and we have to upload a JSON file to the REST. How do we achieve it using informatica Power center. I know we can use HTTP transformation to post data but is there a way we can post a file?  ...
    Ziad Ali
    last modified by Ziad Ali
  • Error handling in IICS data integration mapping task

    Hello All,   I am a newbie to cloud community. I am working on data integration. I created a Mapping task for loading gz file from the S3 bucket to Redshift. I defined schema at source level. While loading into t...
    Chetan Sarawade
    last modified by Chetan Sarawade
  • Loading PDF,csv,txt files into Attachment Object in Salesforce.com through Informatica Power Center

    Hi All,   I have an urgent requirement to load *.pdf, *.txt files (which is in UNIX box) into Attachment Object in Salesforce.com through Power Center. Can you please help/suggest me with some thoughts.
    Senthil Kumar
    last modified by Senthil Kumar
  • Pushdown Optimization

    I want to create a pdo of mapping that has application connection as source. Whenever I am trying to do so, my workflow is crashing. Kindly advice.
    Ninad Magdum
    last modified by Ninad Magdum
  • Looping between source and target

    Hello,   I am stuck and not getting any solution for this. Please help. Below is the requirement Source: Flat File Target: Amazon Redshift table What is happening in Target: Target table is Truncate and load ...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • Need to check incoming date and convert to date format of Target table

    Hello All,   I want to route records having invalid date in one table and dates having valid date records in another table. In router, I created below two groups VALID_RECORDS: IS_DATE(RNT_DT, 'YYYY-MM-DD HH...
    Saurabh Shrivastava
    last modified by Saurabh Shrivastava
  • Split multiple source columns into rows using Java transformation

    Hi ,   I wan to split my incoming source data into multiple rows using Java transformation   Source Data: EmpID,NewHire,Training_Req,TrainingOption,PiTraining 123,No,COMB|LUM|RS,,BY|LN 111,No,,COM-03/06...
    Sanjeev Varma
    last modified by Sanjeev Varma