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
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
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 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
0
votes
1 answer

Access a text file in GCS from Informatica IICS with a parameter source object

I am using IICS to run a taskflow containing two mapping tasks. The data source is set as a parameter and is assigned in an assignment inside the taskflow. In the assignment I set the source of both mapping tasks equal to an input parameter created…
Macrus
  • 69
  • 6
0
votes
0 answers

Is there any documentation or article on how IICS IPU is calculated for different services (CDI, CAI, MI etc)

I did some research online and couldn't find how exactly the IPU is calculated. The only information I got is the different scalars used for different services. Is there any specific formula where the server type (CPU, memory) is a function, for the…
DDJ
  • 5
  • 4
0
votes
2 answers

IICS no viable alternative at input '\n/* partner: Informatica -v 2.0 *

SELECT concat('-', column_1) as column_1, column_2 as column_2, concat('-', column_3) as column_3, 'hard_code_string' as column_4, column_5 as column_5, column_6 as column_6, column_7, column_8 as column_8, …
Rachel
  • 89
  • 3
  • 8
0
votes
0 answers

How to Drop and create new table everytime using Mapping IICS

My requirement is to drop table every time and create new table with updated schema. I have tried with PreSql in Target its not working, getting error as Invalid object table. Also, have used SQL activity in Mapping before calling to target, to drop…
Rakesh
  • 3
  • 7
0
votes
1 answer

How to get flat files with no file structure as source and insert same data into table as target in IICS

I wanted to get the flat files as source without any file structure specified using IICS(Informatica Intelligent cloud services). Flat files names can be anything, and structure also will change any. And also need to create table dynamically based…
Rakesh
  • 3
  • 7
0
votes
1 answer

IICS - populate TIMESTAMP_TZ column with generated value

I am trying to populate TIMESTAMP_TZ column in Snowflake using the Informatica IICS from the Taskflow. In the taskflow I am using function fn:current-dateTime() which I am trying then in the mapping to convert to TIMESTAMP_TZ using the to_date()…
rholdberh
  • 475
  • 1
  • 5
  • 19
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 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
0 answers

informatica elsatic cluster node image

I want to create elastic cluster(CDI) in informatica GUI. I had given all configuration, when I do validate I got following error 1. Cannot find the cluster node image at path [309956199498/RHEL_HA-7.9_HVM-20210315-x86_64-2-Hourly2-GP2] 2. Check…
shas
  • 703
  • 2
  • 8
  • 31
0
votes
1 answer

What is the best approach to load multiple excel files that are on NAS folder using IICS?

I have 50+ excel files on NAS folder that I would like to load to my S3 bucket using IICS. Each file has different column names and number. For loading files. I am using File ingestion task, to be specific "Filelist" as my source object. For…
biggboss2019
  • 220
  • 3
  • 8
  • 30
0
votes
1 answer

How to select Master and Detail for Joiner Transformation containing large records in IICS?

I am using Informatica Intelligent Cloud Services (IICS) Intelligent Structure model to parse the JSON file that I have.The file is located on S3 bucket,and it contains 3 groups. 2 Groups contains lots of records (~100,000) and 3rd group contains…
biggboss2019
  • 220
  • 3
  • 8
  • 30
0
votes
1 answer

How to use Parser Transformation for JSON data in IICS?

I am new to IICS and I have JSON data as below, which I would to parse in csv file. I am using this link as a reference to achieve this transformation. I created valid mapping in IICS.The mapping runs fine. However, when I see my jobs I am…
biggboss2019
  • 220
  • 3
  • 8
  • 30
1
2
3