Stack Overflow
Stack Overflow

Questions tagged [iics-di]

Informatica Cloud Data Integration module is ETL solution that is a part of the Informatica Cloud platform (IPaaS)

37 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

Is it possible to delete records from Hive external table with AWS S3 bucket as location?

Is it possible to delete records from Hive external table with AWS S3 bucket as location using IICS. For example : DELETE FROM MY_HIVE_TABLE WHERE COLUMN1='TEST1';
Anoob K A
  • 59
  • 8
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

Loading distinct rows from flatfile(listfile) to Target using informatica cloud

I have a flatfiles as a source I'm loading 4files at a time using indirect load, here I want to load only distinct rows, if a record present in file1, the same record may contain in file2. So I need to insert only 1 record, the record should…
Intiyaz
  • 9
  • 3
0
votes
1 answer

Loading only distinct records into table via IICS

I have a 4 flatfiles which are coming everyday,I'm taking these r flatfiles as list files as indirect file load. My requirement: I have to load these records in 4 flatfiles into the database. But the problem is I have to load only distinct records…
Intiyaz
  • 9
  • 3
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
0
votes
1 answer

How to compare string with Latin characters to same string with English characters in IICS?

For example, how to successfully compare "André" and "Andre"? I tried some Reg_replace options without any success.
DDJ
  • 5
  • 4
0
votes
0 answers

IICS: How to increase string precision in business services response fields

I have an API call which returns a very very long string, its size is around 885412 characters. But right now I can only capture the first 255 characters of it due to some reasons. Like as you can see from the picture below, when I hang over my…
La. Li
  • 41
  • 6
0
votes
1 answer

How to trigger Informatica mapping task based on output of Snowflake query?

My current company is ingesting data from S3 to Snowflake using Informatica. After the data ingestion job is completed, we are adding a new entry to table called "INFORMATICA_JOBS" that contains the schema and table name, the number of rows…
Aastha Jha
  • 153
  • 1
  • 2
  • 14
0
votes
0 answers

IICS TO_DATE() function formatting question

I have an expression transformation which takes a UTC format string and transform it to datetime object like this: to_date(SUBSTR(from,0,10) || ' ' || SUBSTR(from, 12,8),'YYYY-MM-DD HH24:MI:SS') However, when I check the result, it is not in the…
La. Li
  • 41
  • 6
0
votes
1 answer

How to convert JSON & Excel file to Csv flat file using IICS

How to convert JSON and Excel files to CSV flat files using IICS Data Integration?
Rakesh
  • 3
  • 7
0
votes
1 answer

How to pass Parameters in command task in IICS

How do I pass parameters to command task in IICS Informatica? CMD task is the only task in our task flow. We are calling Linux script in cmd task. I want that everything in Linux script which we are calling from command task like folder path ,prefix…
Karanraj Kasat
  • 13
  • 2
1
2 3