Stack Overflow
Stack Overflow

Questions tagged [iics]

IICS = Informatica Intelligent Cloud Services. Tag usage guidance needs to be added.

Informatica Intelligent Cloud Services (IICS) is an integration platform as a service (iPaaS).

Information: Informatica Cloud Application Integration: A Capabilities Overview (PDF).

63 questions
0
votes
0 answers

Passing Oracle Table partition name as parameter in IICS

I am trying to pass the partition name as an in-out parameter in IICS. select * from xyz partition('$$p_partition') I am getting mostly [informatica][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended error. My param file is fine.…
DDJ
  • 5
  • 4
0
votes
1 answer

How can we use advanced date filter(SYSDATE) in Source while reading the data in informatica iics?

I am unable to use advanced filters in the source of Informatica before reading the data. I want to compare a field with SYSDATE so I am going to advanced filters in Source there is SYSDATE a system variable predefined in Informatica so I am…
Kashish Ahuja
  • 3
  • 1
0
votes
0 answers

How to update a record in Hive table using Informatica powercenter

I'm trying to update a record based on ID field in Hive table using informtica cloud data integration. But the problem is Instead of updating the existing record it is creating new record. Can anyone please suggest better approach
nithin
  • 39
  • 8
0
votes
1 answer

Replicating Data from Azure (PostgreSQL) using IICS

Using IICS, is it possible to replicate data to a data warehouse (local, Oracle) from Azure (PostgreSQL), without installing a secure agent on the Azure instance? I haven't tried anything yet, just trying to understand my options.
Mark
  • 1
0
votes
0 answers

How to stop/kill command task in my jobs which running continuously in IICS

Command task is running continuously if i stopped Task flow manually in My jobs. How to stop this command task. Also, if I run new task flow with command task, the status is showing queued unable to stop these command task. I have stopped Main task…
Rakesh
  • 3
  • 7
0
votes
2 answers

File transfer using IICS

I have a requirement where I need to transfer 1000s of files(around 200 GB) via IICS. How can I perform this using IICS? The files are stored in a server that does not run a secure agent which makes it complicated
DDJ
  • 5
  • 4
0
votes
0 answers

incorrect swagger file path for hosted URL in Informatica cloud (mass ingestion)

I am trying to set up mass ingestion in IICS. This will be a streaming ingestion task. The source is REST V2.   According to the documentation, I can't provide an absolute path to the Swagger file for this connection. Instead, I need a hosted…
farciarz212
  • 1
  • 1
0
votes
0 answers

what is the best way to manipulate an excel file with multiple sheets, having multiple indexes in informatica cloud iics?

I am trying to use the intelligent structure model, but a tree with about 3000 nodes is generated for the file. Since the selection of the nodes is a manual and unfeasible process. Is there another way to do it without ISM?
blackberry
  • 1
  • 1
0
votes
0 answers

IICS Cloud Integration: Is there any way to use a child object in a REST API call through Service Connector?

When using a child object (relatedInvoices in the below example) in the REST API call in a Service connector, I get an error "Unable to parse the payload". The same API call in postman is successful, but not in IICS. Pls let me know if there is any…
Chirag Raj
  • 35
  • 1
  • 5
0
votes
0 answers

Informatica- IICS export- error "ERRO[0000] Exiting with error" while exporting assets from org

While trying to export assets from informatica org using IICS asset management utility, I am getting error "ERRO[0000] Exiting with error" enter image description here
Prasad Boddu
  • 1
  • 1
0
votes
2 answers

Informatica Cloud (IICS): Can Target transformation pre and post sql include incoming data?

I have a Target insert transformation that I'd like to do a delete on the row before insertion (weird niche case that may pop up). I know the update override allows for :TU.xyz to point at incoming data, but Pre/Post SQL doesn't have the same…
Brenton Pyles
  • 1
  • 1
0
votes
2 answers

In Informatica How to Handle nulls coming from SQL Query and Replace the same length of Column Space in Flat Files

For example I have SQL data like this: Col1 Col2 Col3 ----------------------- 0010 01P98 UA500 0010 NULL UA500 I need output in a flat file like this: But I am getting output as below if I use isnull, is_Spaces, ReplaceString etc.…
KotaRavi Kumar
  • 25
  • 2
0
votes
1 answer

what is the equivalent function for FormatNbr(DTSSource("Commission_Rate_2"), 8, 4) in informatica

In DTS function DTSDestination("Commission_Rate_2") = FormatNbr(DTSSource("Commission_Rate_2"), 8, 4) converting the input 652.5 as 06525000 and 9.75 as 00097500 what is the equivalent function to convert column value as 652.5 and required output…
KotaRavi Kumar
  • 25
  • 2
0
votes
1 answer

ADLS connectivity from Linux server using Azure CLI

Does anyone established ADLS connection from linux machine using Azure CLI. Ofcourse we can do this from portal but the idea is to establish from IICS secure agent, which in turn a RHEL server.
Expertos
  • 1
  • 1
0
votes
0 answers

Long running Informatica Job

I am running a job where in source, i have oracle sql query to read the rows, followed by sorter transformation. Below are session logs where we can see after the start of sorter transformation [srt] it takes more than 3 hours to process 410516…
Ankush
  • 1
  • 1
1 2 3
4
5