• Connector for Oracle Fusion Cloud

    Hi Is there a connector through which we can connect to Oracle Fusion Cloud? Thanks
    Retro Flame
    last modified by Retro Flame
  • Wsconsumer IICS

    Does ws consumer transformation support NTLM authentication if the secure agent runs with proxy servers? Please advise
    srini komm
    last modified by srini komm
  • RestV2

    Rest V2 connector is a source, and  target is a flatfile. During the execution of the job, 2 rows of data was read from the source, but that data was not loaded into the target. I looked at the logs, but could no...
    srini komm
    last modified by srini komm
  • wsConsumer

    with the view as a source, I use web services consumer transformation to load the data into webservice. When I run a mapping, I receive the following error .Can any one suggest me how to fix this issue?   CMN_17...
    srini komm
    created by srini komm
  • IICS Connections

    We have the following connectors: web services, webservices(cloud labs ), WS consumer in IICS environment.Can any one suggest to me if there are any differences between these 3 connectors and also suggest to me when w...
    srini komm
    last modified by srini komm
  • IICS Bitbucket Integration for Source Version Control

    Hi, Please let me know how the IICS code source version control can be maintained in Bitbucket.   Can we directly connect and push/pull the code from INFORMATICA CLOUD to BITBUCKET CLOUD
    last modified by Mangesh_Hajare
  • How to load only new data from source to target in  IICS

    Hi,   Please consider the above picture as an example, I am running a mapping from Azure Synapse to Anaplan. In the mapping task I am having a filter SCOPE_ID = 'MN' to only load the monthly data(MN for monthly ...
    Retro Flame
    last modified by Retro Flame
  • HOW TO: Use an single quotation mark/apostrophe in a literal string expression

    Can an single quotation mark/apostrophe ( ' ) be used in a literal string used in an expression?   Yes. This can be done using the ASCII value (39) for an apostrophe with the CHR function with the concatenation...
    last modified by user131593
  • informatica cloud jobs scheduling using other scheduling tools like Control M or Autosys or Tidal etc.

    Hello,   how to run informatica cloud taks like DSS, DRS, MCTs.etc. using other scheduling tools which im currently using in my company to run power center jobs and other jobs like tidal or Autosys or control M ...
    Sai Ram
    last modified by Sai Ram
  • Does Dynamic Schema Handling works with MS SQL (Target)?

    Hi, Can the Dynamic Schema Handling option work with MS SQL?, will it create new columns/Delete Columns If new Columns added in Salesforce object as Source? I don't see any option after selecting Dynamic Schema when...
    Srikanth patevar
    last modified by Srikanth patevar
  • 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
  • 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
  • How to use a Source File with a dynamic name

    I am trying to use Informatica to automate a process that our Business Office has.  Each week, they receive 5 or more files from our Advancement Department.  Those files list donations made each day that wee...
    Diane Royer
    last modified by Diane Royer
  • Extract MetaData from a Flat File

    Is there any way for Informatica to look at the metadata for a flat file used as a source and see the date the file was last saved?   I want to set up a process that I can schedule to run on a nightly basis....
    Diane Royer
    last modified by Diane Royer
  • Spl or junk character to be replaced in Informatica Target file

    Hi Team, I am seeing a spl. character - Â when i convert the UTF-8 file to ANSI. I want to remove this junk in my target file. I tried using CHR(182), and CHR(194). Both did not work. Can you please tell the cor...
    User6392 N
    last modified by User6392 N
  • syntax error in my expression

    I wrote this expression: IIF(Program_Code = '3GBA242AMBA', AND (Concentration_Code_1 = 'R098' OR Concentration_Code_2 = 'R098'), Decode(Attribute_Codes, '3M07', 'Paris Island')) but I get a syntax error. I've gone th...
    Thomas Kennedy
    last modified by Thomas Kennedy
  • Azure Data Synapse

    Hi, What connector do I use to connect to Azure Data Synapse? Is it the SQL Connector?
    Retro Flame
    last modified by Retro Flame
  • IICS

    we use the following components i.e. Metadata Manager ,Informatica Analyst and Business glossary in Informatica 10.1.0.   We installed IICS ,but how do we implement the Metadata Manager,Informatica Analyst and B...
    srini komm
    last modified by srini komm
  • IICS Cloud: filter query dinamically with values of a column

    Hi,     I would need to create a filtered query loop in the where for a column's values. I can't find a solution among the documentation. Has anyone ever done a query that filters for a dynamic value taken ...
    last modified by ANNA IANNACE
  • Dynamic mapping from File share ADLS Gen2  to ADLS Gen2 Blob container

    We have a requirement from client where we have dynamic flat files in .txt  format and vendors are dropping them into "File share" of Azure ADLS Gen2.   1. Do we have a connection from IICS to connect to Fi...
    Ravindra M
    last modified by Ravindra M