to follow, share, and participate in this community.
Not a member? Sign Up!
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.... 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 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... 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... 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 ... I can see below items in ingestion log and need to understand what they mean and what happens during those phases. Please someone explain below items. Please share any document which details about scanner and profile... I want to upgrade from Informatica 9.0.1 to 10.2 and I Installed windows 2012 R2 initially and copied previous version folder to new machine for upgrade.When I start the installation of Informatica 9.5.1 this gives er... Hi, I want to run one of our taskflow continuously until I finish all the files in a windows folder. This task can process only one file at a time. Currently i am running this task using 5 mnt infomatica...