• 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
  • I am new to Informatica and need to understand scanner,injestion and profiling phases in detail.

    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...
    Mithun Karanth
    last modified by Mithun Karanth
  • Informatica Upgrade from 9.0.1

    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...
    Ashish Pandit
    last modified by Ashish Pandit
  • RunAjobCli using Powershell

    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...
    Shabeer Madathil
    last modified by Shabeer Madathil
  • REP_SESS_TBL_LOG Dups rows

    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...
    Mohit Verma
    last modified by Mohit Verma
  • Connet to MSSQL Server with Windows Authentication

    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...
    Federico Fanalista
    last modified by Federico Fanalista
  • HOW TO GET THIS?

    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...
    Ajay .
    last modified by Ajay .
  • How can I choose selected pipeline in mapping for debugger

    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...
    Karthik G
    last modified by Karthik G