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

How to implement audit logging mechanism in IICS through data integration it would be helpful if some one answer

Can someone help me how to implement audit logging mechanism in IICS through data integration..like capturing success rows failed rows. I have tried by creating 2 table where one is having mapping info and one is Audi info and created mapping but…
Nikhila
  • 1
  • 1
0
votes
0 answers

How to load semi structure data from a table to file in iics

need help I have a table called customer and it ishaving below fields Customer_id | payload | created_dt | modified_dt Here payload is json format and remaining fields are relational. I want to convert json data into relational and load all the data…
nithin
  • 39
  • 8
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
2 answers

S3 dynamic csv file into Snowflake

I possess a dataset stored in Amazon S3 that I desire to ingest into Snowflake using IICS (Informatica). This dataset is formatted as a CSV file, which corresponds to the structure of the tables I aim to create or update in Snowflake. However, the…
Nesmo07
  • 15
  • 3
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
0
votes
1 answer

IICS Extracting JSON Data from REST API and then Loading to Relational Database/Datawarehouse (Snowflake)

I am new to informatica cloud. I am learning to integrate data from REST API right now. my purpose is to build an ETL to extract data from REST API and then directly Load data into snowflake. I am using IICS data integration to do this. However, I…
La. Li
  • 41
  • 6
0
votes
2 answers

Varying number of csv files from Amazon S3 as input to Informatica cloud

I have multiple csv files in Amazon s3 bucket in the same format.But the number of files may change on a daily basis. It maybe 2 in a day and 0 on other days. How can I create an Informatica cloud flow task to read from these varying number of csv…
user2280352
  • 145
  • 11
0
votes
1 answer

IICS expression mapping

I have an IICS mapping expression transformation with a variable field -'flag'.It has a precision of 1 and expression 'N'. The target field is an Oracle database column with varchar2(1). But after successful execution of the mapping, the column is…
user2280352
  • 145
  • 11
0
votes
1 answer

How can we Check Uniqueness in Informatica CDQ without Aggregator (Active Transformation), so it can be applied in Rule Specification

How can we Check Uniqueness in Informatica CDQ without Aggregator (Active Transformation), while using Active Transformations like Aggregator or Sorter, its throwing the error that "The mapplet is active. Only passive mapplets can be added in Rule…
Sam G
  • 1
0
votes
0 answers

IICS data preview issue with SQL Server stored procedure

New to IICS, when build mapping to populate data by EXEC stored procedure from source, I can preview data from query editor. But when I tried to run preview from source and I got nothing return. Any idea? Preview Data from Query Editor I can preview…
Tako
  • 1
0
votes
0 answers

IICS New Swagger File Challenges - Truncated Headers

Background:I am attempting to create a New Swagger File in IICS, however, am facing challenges authenticating via Bearer token, due to truncation w/authorization headers.SpecificsAs the API I am calling uses Bearer Token authentication, I believe I…
William
  • 191
  • 5
  • 32
1
2
3 4 5