• [ICMD_10033] Command [UpdateParameterSetEntries] failed with error [[DsCore_10124] Scope descriptor [DEV_Part1/Consolidation_Shared/Mappings/m_CUSTOMER_GEO_DATA] is not valid.].

    I am facing an issue when updating parameter set through commands.   Following is the UpdateParameterSetEntries command.   infacmd.sh dis UpdateParameterSetEntries -dn infa_presales_cloud -sn presales_dis ...
    Shital Katkar
    last modified by Shital Katkar
  • MDM Java Cleanse Function

    Requirement:   I have two BO tables- Party & child BO- Party Name Data is loaded in MDM via BES & is sent via a pipeline (payloads) wherein the sequence of the triggers/request is ideal i.e. not necessa...
    niti rawat
    created by niti rawat
  • Use input port in lookup override

    Hi Gurus,   I am working on logic where i need to do lookup on table but the value in source will not match with lookup as there are few other words attached to source value(i cannot cleanse that so out of quest...
    Nitish Sharma
    last modified by Nitish Sharma
  • SPN Configuration - EDC

    We are having issues with setting up our SPN's for our Enterprise Data Catalog installation.  i need someone to validate the script and if I need to do anything on my AD account
    Wes Hendrix
    last modified by Wes Hendrix
  • Search for SQL in IDQ Repository

    i'm using this query againsts the IDQ repository to find all my SQL Overrides for READ and Lookup Transformations Does this do the trick. It seems to find READ but i don't think its pulling from Lookup. select PO...
    Marvin Mondejar
    last modified by Marvin Mondejar
  • Informatica 10.4.0.1 is Now Available

    What are we announcing?Informatica 10.4.0.1 Who would benefit from this release? This release is for all Data Engineering and Data Catalog customers and prospects who want to take advantage of the updated Hadoop dist...
    Rashmi Rekha Gogoi
    last modified by Rashmi Rekha Gogoi
  • Message Code: HIER_28056  XML Reader: Error [ExpectedCommentOrPI]

    Hi i haved this error, Message Code: HIER_28056  XML Reader: Error [ExpectedCommentOrPI] occurred while parsing:[FATAL: Error at (file EMPTY, line 73, char 1 ): Expected comment or processing instruction.]; line...
  • Merge Option not Appearing for Relationship Table in IDD

    Hi,   Here is the problem statement where we need a resolution.   We have an IDD application dealing with Customer data. The proper subject areas have been created and it works fine. But we are facing one pr...
    S Raja
    last modified by S Raja
  • nEED TO EXECUTE REGULAR EXPRESSSION based on the country code

        @ I have a scenario wherein regular expression is to be applied on a few source columns based on the country. I created a managed reference table in Informatica Developer with two columns Country code...
    niti rawat
    last modified by niti rawat
  • No data in Repository table

    Hello ,   Recently our database has migrated from an old server to a new server. But there is no data in repository tables , and maily we are concenered with REP_SESS_LOG. Can you please help us troubleshoot...
    lavina.agarwal@tcs.com
    last modified by lavina.agarwal@tcs.com
  • Informatica 10.4 is Now Available

    What are we announcing? The release of Informatica 10.4   Who would benefit from this release? This release is for all customers and prospects who want to take advantage of the latest PowerCenter, Data Engineerin...
    Rashmi Rekha Gogoi
    last modified by Rashmi Rekha Gogoi
  • Dynamic lookup cache is not updating NewLookupRow to 2 for the existing record.

    Scenario I am facing is we have couple of records coming from source are having duplicates. we have a composite key [ID1 and ID2] defined at the informatica level and not at the DB level. let's assume there are two re...
    EC77452
    last modified by EC77452
  • Differences between Informatica PowerCenter and DataQuality

    Hi Experts,   Hope all are doing good!!   I would like to know the key differences between Informatica PowerCenter and Data Quality. Also, What are the additional features/options present in Data Quality ove...
    Mota Sreenivasulu
    last modified by Mota Sreenivasulu
  • How to use a timer task with an Event wait task?

    I have a requirement where I have to check for a Control file when the workflow is executed. If the control file is present then run the session. If not wait for 30 minutes. Check again after 30 mins. If still the con...
    Richa00u12u4m3lajY6toe1d8
    last modified by Richa00u12u4m3lajY6toe1d8
  • Athena JDBC driver setup issue

    Hi all,   Can someone please advice how to setup Athena JDBC connection in informatica 10.1?   I downloaded v2 driver from Using Athena with the JDBC Driver - Amazon Athena Put in in my jar directory set...
    Alexander Kolesnikov
    last modified by Alexander Kolesnikov
  • Issues in migrating from 9.6.1 to 10.2

    Hi All, we are recently migrating from 9.6.1 to 10.2 informatica PC with SQL server as application database i am facing two issues actually   1) for one of the mapping where we are getting error as , value too...
    mayur marathe
    last modified by mayur marathe
  • Error - ORA-12899 (value too large for column)

    Hi,   I have a CLOB column in the source which is having character > 4000. While loading the data into varchar field(4000), I used the below logic: TO_CHAR(SUBSTR(COLUMN_NAME,1,4000))   still, there ar...
    Amit Jain
    last modified by Amit Jain
  • configuring Admin console url

    Hi   I would like to configure my Admin console url into an alias name. Can we do it in Informatica?   I do not want the url to have server name on that.   or do we need to take help of any DNS te...
    Sundeep Pillamari
    last modified by Sundeep Pillamari
  • How to create a Step in an APi Call to write to a Database table

    Hello,   I currently have a Get API process that is retrieving orders with data such as order number and customer name and then doing a POST API call to another application. However, I would like to do store eac...
    inuser515563
    last modified by inuser515563
  • End of Life Announcement for Solaris 11

    What is being announced?  Starting with the release of Informatica Platform 10.4, Solaris 11 Server will no longer be supported. Informatica Platform is a set of data services and information solutions powered by...
    Rashmi Rekha Gogoi
    last modified by Rashmi Rekha Gogoi