• 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
  • 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
  • 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
  • IICS parquet files

    Hi All, Thank you   can Informatica cloud  IICS read parquet files?  Also, see whether Informatica can derive the column names automatically from parquet files.   Another one is whether Informa...
    Preethish Rahul
    created by Preethish Rahul
  • File Reader with Same Date

    Hi Team,   I have a scenarios, I have to read a file daily " File_Name_date.txt " load to Table. Same Date file may come multiple time in a day so If the same Date file process again then i need to Delete all the...
    SP K
    last modified by SP K
  • Informatica Framework

    Hi Team,   How the frame work will help for a desgn in informatica, Can i have some frame works that may help full for the project for a specific requirements.   Thanks spk
    SP K
    last modified by SP K
  • Derive Value in a Group based on one column

    Hi , I have the below data and i would like to populate a column as shown . In a group , first record should get compared with all other records and relationship with other records should be stored in output column....
    Abhidha P
    last modified by Abhidha P
  • Power Center Grouping Scenario

    Hi , I have below data and want to get the output as given below , please help.    Source Data   CUST_ID GROUP_ID 101 1 102 1 103 1 104 2 105 2 106 2 107 2 108 3 109 3 110 3 111 3 112 4 113 4 114 5 ...
    Abhidha P
    last modified by Abhidha P
  • 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 o...
    Mota Sreenivasulu
    last modified by Mota Sreenivasulu