Informatica Cloud Data Integration module is ETL solution that is a part of the Informatica Cloud platform (IPaaS)
Questions tagged [iics-di]
37 questions
0
votes
1 answer
Informatica Cloud Data Integration - find non matching rows
I am working on Informatica Cloud Data
Integraion.I have 2 tables- Tab1 and Tab2.The joining column is id.I want to find all records in Tab1 that do not exist in Tab2.What transformations can I use to achieve this?
Tab1
id name
1 n1
2 n2
3 …
user2280352
- 145
- 11
0
votes
1 answer
Can I connect to API using Informatica Cloud service?
Can I connect to API using Informatica Cloud service? If yes, can you please guide me through process? I am new to Informatica Cloud service, so please provide example along with explanation.
biggboss2019
- 220
- 3
- 8
- 30
0
votes
0 answers
How to process salesforce error files in informatica cloud
we are integrating data into salesforce from Hive database source using informatica cloud.
But when we use SFDC standard API,its generating error file with all rejected records.
Here we have to re-process the error file to make sure all source…
nithin
- 39
- 8
0
votes
2 answers
Read file in informatica (IICS) from sftp source
I want to read file file_DDMMYYYY.csv from a sftp server and load into target table through informatica Intelligent Cloud Services (IICS)
It is going to be a daily job so file name will keep changing to contain today's date
There are two questions…
Harsh
- 27
- 7
-1
votes
1 answer
How to skip the target write in case zero record count in Informatica Cloud (IICS)?
I have one use case to create incremental Data ingestion pipeline from one Database to AWS S3. I have created a pipeline and it is working fine except for the one scenario where no incremental data was found.
In case of zero record count, it is…
Nikhil Suthar
- 2,289
- 1
- 6
- 24
-1
votes
1 answer
Informatica Cloud - File Name with Date
I have oracle (12c) table with column names from_dt, to_dt.
create table param ( name varchar2(10), from_dt date, to_date date);
insert into param values ('Test', '03-FEB-2022', '04-FEB-2022');
I want to append the to_dt value (in format…
Ras Knorr
- 43
- 6