to follow, share, and participate in this community.
Not a member? Sign Up!
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... 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.... 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... 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 ... 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... 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... 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 ... 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... 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... 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... 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... 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... 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... 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 How do I add another team member with the same access I have to the tech support site? 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... 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! 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 ! 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... 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...