• How to store JSON array data into one column in SQL table?

    I am using IICS to do ETL. My source is a JSON file. I am using Hierarchy parser to parse that JSON and load the output into database. Everything is going fine except one thing. Within that source JSON file there is o...
    Aniruddha Gayake
    last modified by Aniruddha Gayake
  • CMN_1022 [Database driver event...Error occurred loading library [libodbc.so: cannot open shared object file: No such file or directory]

    Hi,   I'm using Informatica developer of version 10.5.1, we have created connection with SQL Server Database and the connection is successful. While adding read component in the mapping for the particular connec...
    Jyoti Rathod
    last modified by Jyoti Rathod
  • Informatica Power Center Installation with File Descriptor limit less then 16000

    Hi Everyone,   I am facing File descriptor limit issue when run pre check tool, increasing limit is taking time because i dont have sudo user access. My question is can i move with installation with limit 4096 ?...
    asim khalil
    last modified by asim khalil
  • Full encryption?

    Is there a way to run Informatica MDM in an encrypted mode so that nobody from Informatica themselves or from the cloud provider could gain access to plain text data?   As a more concrete question: Is a setup p...
    Martin Treder
    last modified by Martin Treder
  • Informatica 10.4 is Now Available

    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...
    Rashmi Rekha Gogoi
    last modified by Rashmi Rekha Gogoi
  • Is this still available?

    Is this still available?
    user140700
    last modified by user140700
  • Migration from Informatica 9.5.1 to Informatica Cloud

    Hi All,   I am exploring option to migrate on premise Informatica 9.5.1 to Informatica cloud. I have very less information on informatica cloud so thought to check on this forum. Looking forward for your inputs...
    Asmita Joshi
    last modified by Asmita Joshi
  • BDM log

    Hi   The BDM service was down and I am looking for the log that can tell me what happened.   Could anyone direct me please to the appropriate BDM log file ?   Thank you, Tamir
    Tamir Basin
    last modified by Tamir Basin
  • Powercenter to IICS Migration

    Hi,   I am going to work on a new project where we have to migrate the jobs from PC to IICS. In order to move forward with this, I would like to get inputs from anybody on the below.   1. What are the pre-...
    Jaiganesh Natarajan
    last modified by Jaiganesh Natarajan
  • SSL Connect ERROR

    i am not able to access Designer, workflow on Informatica Powercenter. ERROR : PCSF_46024 SSL has failed because of SSL connect Error Also, I cannot access the Admin Console. Below are details : infacmd.sh ping ...
    Aparna Razdan
    last modified by Aparna Razdan
  • Need to know if Informatica 9.6.1 is compatible with Oracle Linux 6

    Hi Team,   We have planned for Migration of Informatica 9.6.1 from On prem (IBM AIX 7.2) to OCI (Oracle Linux 6.10) We know it is compatible with RHCK Kernel series 2.6.32 which is present in Oracle Linux 6. P...
    Kaviraju P
    last modified by Kaviraju P
  • Add structure group via REST API

    I am attempting to add a structure group via the REST API, but am receiving the following error:   Unable to perform operation due to an unknown error. Please try again or contact your PIM administrator or the S...
    inuser462414
    last modified by inuser462414
  • Informatica 10.5.1 is Now Available

    What are we announcing? Informatica 10.5.1 Who would benefit from this release? This release is for all customers and prospects who want to take advantage of the latest PowerCenter, Informatica Data Quality, Data En...
  • ORA-12660: Encryption or crypto-checksumming parameters incompatible

    Hello Team,   Kindly help me in resolving the below issue.   Issue Description: ===============   On Informatica version : Informatica 10.1.0 ,Customer is not able to start their informatica servic...
    Ananth Suman
    last modified by Ananth Suman
  • IDQ - Comparison Transformation

    Hi All,   I am using comparison transformation in my mapping to compare LAST_NAME in one table but it always returns 1 for all the records , means all the records has duplicate  which is not correct . Pleas...
    Abhidha P
    last modified by Abhidha P
  • Filter Transformation Pushdown Optimization

    Hi,   I am using a filter transformation just after the source object. I have read some articles regarding the filter pushdown that the query you have written in filter transformation is processed by the the sou...
    Munesh Yadav
    last modified by Munesh Yadav
  • Process Object is not getting loaded into cloud process

    In our informatica cloud environment whatever a Process Object I create and try to load it in a Cloud process is not happening.. but process object is successfully getting created .. no error but still its weird.. bec...
    mani vincent
    last modified by mani vincent
  • PMUDT_50025 : Streamer failed to find next segment

    Hi Everyone,   I am getting below error while transforming my data using unstructured data transformation. PMUDT_50025 : Streamer failed to find next segment   I am able to parse my data with Informatica ...
    Informatica Ops
    last modified by Informatica Ops
  • Need suggestion on Kernel Compatibility for Informatica in Oracle Linux

    Hi ,   We would need to understand whether RHCK Kernel 3.10.0-1160.36.2.el7.x86_64 is compatible/certified with Informatica (9.6.1, 10.2.1 & 10.4.1) in Oracle Linux OS (7.9).   Please confirm if the ab...
    Kaviraju P
    last modified by Kaviraju P
  • Informatica Process Server not launch due to PostgreSQL database

    Hi,   I can't start the Process Server, but the Common Integration Components and the Data Integration Server are running.   At the bottom I brought logs, which show the problem with starting PostgreSQL an...
    Andrei Pisarev
    last modified by Andrei Pisarev