to follow, share, and participate in this community.
Not a member? Sign Up!
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... 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... Hi Masters, I have a mapping which is loading 3 tables. I was looking to check the metadata information of this mapping's session like success rows, failed rows etc. I thought that this information can be fetc... Hello I'm trying to connect some services to MSSQL Server with Windows Authentication without any success. Only Domain and PowerCenter Repository show me the option "Trusted Connection", in this case I'm able to ins... SOURCE TABLE ID NAME 10 RAJA 10 KIRAN 20 SREENU 20 VIJAY 10 AKASH 20 TEJA 30 RAJU TARGET TABLE ID NAME 10 RAJA,KIRAN,AKASH 20 SREENU,VIJAY,TEJA 30 RAJU TELL... Hi All, I'm using debugger for a mapping which has 2 pipelines, in 1st pipeline i almost have 8 lakh records, but i want to check the data for 2nd pipeline , so how can i skip the 1st pipeline and choose the 2...