• IICS  Hierarchy builder transformation creates multiple XML roots rather than a single XML file

    @@@@@Hi I have source like below (flat file)   Employeeid~Firstname~Lastname~Addressid~address_Employeeid~Line1~Line2~City~State~Zipcode 102~TEST1~P~1101~2099~ABC~DEF~Hyderabad~TS~500015 103~TEST2~q~1101~209...
    shafi sk
    last modified by shafi sk
  • Secure Agent - runAJob CLI - create an encrypted password

    Hello,   I'm trying to create an encrypted password for runAJob Cli utility. But, i'm getting below error and i was trying to execute the command from root user.   /proj/app/SA/downloads/package-runAJobCli...
    Thanigaivel Govindan
    last modified by Thanigaivel Govindan
  • Mapping with webservice transformation failing with The DTM process terminated unexpectedly. Contact Informatica Global Customer Support error

    Hi All, I'm trying to run a mapping with webservice transformation, it is failing with DTM process terminated error. When i observed the log it has below error.   MAPPING> PMJVM_42009 [2021-05-13 07:38:46.4...
    pereddy seshaseyanareddy
    last modified by pereddy seshaseyanareddy
  • How to Capture Strace for IICS Tasks

    Open video

    Arun Som
    created by Arun Som
  • How to Use Sorter Transformation in IICS

    Open video

    Arun Som
    created by Arun Som
  • How to Parameterize the endpoint URL for Web Service Consumer Connection / transformation in IICS - ICDI

    I have created a parameter like $$WSC_ENDPOINT_URL and I have specified the ENDPOINT URL as $$WSC_ENDPOINT_URL. Endpoint URL is not picked correctly when mapping tasks is running and it results in a task failure. ...
    Thanigaivel Govindan
    last modified by Thanigaivel Govindan
  • 2 Agents in one group is there a way to have a mapping task always use one?

    So we have an agent group that has 2 agents in it.  One is located in Azure and one is at a physical location.  Some mappings are faster going through one agent vs. the other, depending on the physical locat...
    David Cribbs
    last modified by David Cribbs
  • Discontinuation of “Web Services” and “Web Services V2” connectors in July 2021 Major Release

    What are we announcing? Discontinuation of “Web Services” and “Web Services V2” connectors   When is this being performed? These products will be discontinued with the release of July M...
    Abhijit_Das
    last modified by Abhijit_Das
  • July 2021 Major release for US West 5 and US East 6 pods

    7/24/21 9:00 PM
    July 2021 Major release for US West 5 and US East 6 pods   More details on the upgrade and what it includes will be available in the coming weeks.
    Abhijit_Das
    last modified by Abhijit_Das
    July 2021 Major release for US West 5 and US East 6 pods
    Back
  • July 2021 Major release for Canada Central 1 and US West 1 GCP pods

    7/24/21 6:00 PM
    July 2021 Major release for Canada Central 1 and US West 1 GCP pods   More details on the upgrade and what it includes will be available in the coming weeks.
    Abhijit_Das
    last modified by Abhijit_Das
    July 2021 Major release for Canada Central 1 and US West 1 GCP pods
    Back
  • July 2021 Major release for EM West 1 and US West 3 Azure pods

    7/18/21 9:00 AM
    July 2021 Major release for EM West 1 and US West 3 Azure pods   More details on the upgrade and what it includes will be available in the coming weeks.
    Abhijit_Das
    last modified by Abhijit_Das
    July 2021 Major release for EM West 1 and US West 3 Azure pods
    Back
  • July 2021 Major release for US West 3, US East 4 and AP SouthEast 1 pods

    7/18/21 6:00 AM
    July 2021 Major release for US West 3, US East 4 amd AP SouthEast 1 pods   More details on the upgrade and what it includes will be available in the coming weeks.
    Abhijit_Das
    last modified by Abhijit_Das
    July 2021 Major release for US West 3, US East 4 and AP SouthEast 1 pods
    Back
  • July 2021 Major Release for US West 1 Azure and  AP NorthEast 1 Azure pods

    7/11/21 9:00 AM
    July 2021 Major release for US West 1 Azure and  AP NorthEast 1 Azure pods.   More details on the upgrade and what it includes will be available in the coming weeks.
    Abhijit_Das
    last modified by Abhijit_Das
    July 2021 Major Release for US West 1 Azure and  AP NorthEast 1 Azure pods
    Back
  • Does my double quote piped source file need to be converted before processing in Informatica?

    I am creating a synchronization task to update records and will be receiving a pipe delimited double quotes file with all the data in a single column. An example is below, which shown column headers then source data: ...
    Thomas Kennedy
    last modified by Thomas Kennedy
  • set default value when more than one rows return in lookup

    Hi ,   I have created one lookup in information CDI tool as follows. Now the issue is this lookup returns more than one rows. What i want to rather than information generates the error when more than 1 output v...
    Nihar BHATT
    last modified by Nihar BHATT
  • Creating Mappings using API

    Hi Team,   Is there a way where I can create a mapping and related logic ( transformations ) using Rest API's ? So lets say i have some logic written in Talend ETL, now i have to convert that into IICS mapping. ...
    Siddharth Dutta
    last modified by Siddharth Dutta
  • Sharepoint to S3

    Hi All,   Im trying to build a sync task in IICS which will copy all the files from my sharepoint to S3.   The task worked well but problem is when only the metadata is getting written as CSV as i choose ...
    Premkumar S
    last modified by Premkumar S
  • Add a new column through informatica

    Hi, I am importing data from Azure synapse to Anaplan using informatica but I need an additional column in the source before I can load the data. I need a column for numbering ( 1,2,3,etc). How can I achieve the same...
    Shawn Mathew
    last modified by Shawn Mathew
  • IICS plans to drop support for Internet Explorer 11 browser

    November 17, 2020   Upcoming dropped support of Internet Explorer (IE) 11 and transition to Chromium-based Microsoft Edge  Microsoft announced that they will drop support for IE 11 on August 17, 2021. In prepar...
    gcook
    last modified by gcook
  • SQL Connection Type

    Hi, I installed secure agent in a VM server and established connection to Azure Synapse using Microsoft SQL Server Connection Type. Connection was tested and was successful but when I try to import data from synapse,...
    Shawn Mathew
    last modified by Shawn Mathew