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
1
vote
1 answer

Informatica: dealing with double quotes using expression tranformation

I am developing a mapping in IICS CDI which takes API response as source and save it to a comma delimited .txt file (flat file target). In the response from the API, since some of the fields contains comma sign "," that field will be surrounded with…
La. Li
  • 41
  • 6
1
vote
1 answer

IICS Error: "Concatenation disallowed on transformation Joiner. "

I want to join two datasets that are coming from the same source. And I got this concatenation disallowed error. Below are some details about my problem scope: For the source: I am extracting from REST API, after parsing the JSON output, there will…
La. Li
  • 41
  • 6
1
vote
1 answer

Informatica Cloud Expression Transformation Convert UTC String to DateTime

I want to convert the UTC datetime in string format to datetime format: "2016-05-12T21:19:51.2946214Z" -> 2016-05-12 21:19:51.294 I tried to first remove the letters in the original string by using the SUBSTR() function, and then convert the…
La. Li
  • 41
  • 6
1
vote
2 answers

REG_EXTRACT doesnt work in IICS Informatica

I have a value (URL) https://test.com/insight/api/view?entity_type=event&entity_id=6557856 and when I am trying to apply this function: REG_EXTRACT (value, 'entity_id=(\d+)',1) i am getting NULL instead of a proper value. https://regex101.com/…
rholdberh
  • 475
  • 1
  • 5
  • 19
1
vote
1 answer

How to generate flatfile with zero records when there are no records in source?

I'm doing incremental data load from relatioal db to dynamically created flat file. Suppose if there are no new records in source the mapping not creating target file. I need a empty Target file if there are no records fetched From source
nithin
  • 39
  • 8
1
vote
1 answer

Informatica - Concatenate Max value from each colum present in multiple rows for same Primary Key

enter image description here I have tried traditional approach of using Agg (Group By: ID, Store Name) and Max(Each Object) columns separately. Then in next expression, Concat(Val1 Val2 Val3 || Val4). How ever, I'm getting output as '0100'. But,…
Aki
  • 11
  • 1
1
vote
1 answer

Change Snowflake WH Size before Run in Informatica

When running an Informatica IICS job into Snowflake, the batch warehouse is sized for the biggest jobs. Is there a way within Informatica to alter the warehouse size so that we can run with a smaller WH for most of the jobs but then scale it up when…
user3890455
  • 19
  • 8
1
vote
1 answer

how to convert 99.0000 to 009900 in informatica iics

In DTSDestination("Ann_Non_Comm_Prem") = FormatNbr(DTSSource("Ann_Non_Comm_Prem"),6,2) converting the input 0.0000 as 000000 and 99.0000 as 009900 what is the equivalent function to convert column value as 99.0000 and required output as 009900 in…
KotaRavi Kumar
  • 25
  • 2
0
votes
1 answer

Distribution List in Notification Task in IICS

Can we add distribution lists in notification task in IICS, I tried the below and it's not sending any emails to the DL's. Could you please suggest if there's any alternative for the same. Note : It's working for Individual emails. Thanks!!
vinay kumar
  • 41
  • 1
  • 6
0
votes
0 answers

Looping in Informatica Cloud

I have an excel where data is present in key-value format. Id D-id 2 Null 14 2 110 14 203 110 Here 203 is linked to 110, 110 is linked to 14, 14 to 2. My final goal is to map 203 to 2. Final output will look like Parent Child 2 …
Arindam Basu
  • 1
  • 1
0
votes
0 answers

Aggregator transformation

What would happen if we didn't mention any condition and did not opt for the group by aggregator transformation? if we pass the 20 records at the source side how many records will load into the target what will be the result
Anitha Mahalakshmi Bandaru
  • 1
0
votes
1 answer

In IICS, I want to fetch the MAX value of a column through mapping

Here is a sample source table REGION_CODE TIER 093 4 091 5 090 1 096 null Target Table REGION_CODE D_REGION_CODE_ID TIER Right now the target table will be empty, I want to find the MAX value of…
rohanK0602
  • 3
  • 2
0
votes
1 answer

IICS: multiple queries into one flat file

I'm just learning my way around Informatica's IICS and wanted to do something that I figured should be simple: I'm trying to get record counts from multiple Salesforce databases into a single CSV. I can't do this with a single SOQL query, so my idea…
lengthy_preamble
  • 404
  • 3
  • 14
  • 35
0
votes
0 answers

How to create a rest web service in informatica cloud (IICS)?

I couldn't create a web service in informatica cloud similar to the one we create in informatica BDM. I need to create a web service from which I should be able to pull data from necessary schemas/Tables. I tried using CAI in informatica cloud to…
sriramvel Manickam
  • 1
0
votes
1 answer

IICS: How to deal with API which returns first character as a number but not letter?

Hi informatica developers, I am working on a XML-based REST API. I want to get the data from the API and save it to a flat file. However, one problem is that this API is returning the object whose first character starts with number but not letters.…
La. Li
  • 41
  • 6
1
2 3 4 5