• 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
  • 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 ove...
    Mota Sreenivasulu
    last modified by Mota Sreenivasulu
  • 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
  • Windows Client install files

    Does someone know why Win Client installation zip file is so big and has 6.1 GB ? What is included in this file ?, it is biggest then server installation pack ...
    Konrad Mokrzanski
    last modified by Konrad Mokrzanski
  • FATAL ERROR : An unexpected condition occurred in file [/export/home/builds/pc9x_root/1020/build/powrmart/server/dmapper/trans/srcpipe.cpp] line [1383].  Aborting the DTM process.  Contact Informatica Global Customer Support

    Hi,   I have created a mapping to update some columns in the target target Table and the connection type that is used is TPT Connections. My source and target is table (Teradata). And the job is successfull and...
    Shivani Jaiswal
    last modified by Shivani Jaiswal
  • FnName: Execute -- [Informatica][CassandraODBC] (10) Error while executing a query in Cassandra: [33563136] : String didn't validate.

    Hi ,   I have an issue while loading the data into Cassandra , f ew of records get rejected due to Presence of some characters . Below is the error message   FnName: Execute -- [Informatica][CassandraODB...
  • 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
  • TT_11019 TRANSFORMATION ERROR FIX IT

    INFORMATICA TRANSFORMATION ISSUE (PROD) My Mapping is going down with the error message code :TT_11019" and the Mapping logic is as stated below # Source1(DB2)------>   SOURCE QUALIFIER--->Expression...
    Prasanth G
    last modified by Prasanth G
  • Expression will not work

    Why would this expression work in one mapping, but not another? I've created a column to list the event_dt if the the event_cd is not blank or null, but the expression seem to be ignored altogether.  However, the...
    theladyd
    last modified by theladyd
  • Usage of Volatile tables in SQL Transformation

    I'm facing an issue in Infa 9.6 environment. I'm trying to use SQL transformation in query mode.   CREATE VOLATILE TABLE ADMIN_TEST ( CA_ID INTEGER, CASE_ID INTEGER ) PRIMARY INDEX(CA_ID) ON COMMIT PRESERVE R...
    Naveen Manoharan
    last modified by Naveen Manoharan
  • IIR 9 monitoring

    I'm running IIR V9.5.3 in windows workstation and what would be the best way to monitor if services are up through window services or tasklist? Since it does not have a monitoring application thats comes in IIR 10.x
    Dilan A
    last modified by Dilan A
  • Adding another support tech to our company access

    How do I add another team member with the same access I have to the tech support site?
    John Nester
    last modified by John Nester
  • Repository Query to get all SOurce & target connections including source & target flat file

    Hi,   I was able to get hold lots of repository query to get a list of source and target DB connections but what i also require is a list that provides me any type of connections and their values - Ex: IF I have...
    vishwakumar Palamadai
    last modified by vishwakumar Palamadai
  • Is Oracle 19c is compatible with informatica v10.1.1?

    Hi All,   There is a Db upgrade on our way .So, I would like to know whether oracle 19c is compatible with  informatica v10.1.1 ?   Thankyou!
    swetha moorthy
    last modified by swetha moorthy
  • Informatica support case

    Hi,   I need to open a case with informatica support team. Could you please help me out with the process? Help will be appreciated.   Thankyou !
    swetha moorthy
    last modified by swetha moorthy
  • Informatica Cloud (IICS) Mapping Automation

    Hi Gurus,   I am trying to extract data using IICS. My mappings are simple, source -> target, 1 to 1 mapping. I was wondering, if there is a way to a) generate mappings automatically (code, api calls) to crea...
    inuser475621
    last modified by inuser475621
  • Informatica upgrade 9.1 to 10.2

    Hi Team,    My team is planning to upgrade the 9.1 to 10.1.As asked to create the parallelenvironment to do this activity . As per upgrade document we need to follow 9.1-->9.6.1-->10.1 path . I have...
    shalabh srivastava
    last modified by shalabh srivastava
  • Java Transformation question

    I'm using JAVA transformation in my mapping(IDQ v10 ) with source being read from Oracle DB. When I run mapping locally it's working good as expected but when I run the workflow via Autosys job,it's not even trying ...
    Sandeep Paturu
    last modified by Sandeep Paturu