Indirect loading of AWS S3 files using Informatica Cloud (IICS)
Learn how to read multiple files from Amazon S3 and write to single target in IICS using manifest file through Indirect Loading method.
Informatica Cloud (IICS) Architecture
Informatica Cloud(IICS) is a next-generation iPaaS solution offered by Informatica which offers a suite of cloud-native services.
HOW TO: Implement SCD Type-2 using Dynamic Lookup in Informatica Cloud (IICS)
SCD Type-2 Implementation using Dynamic Lookup transformation in Informatica Cloud Data Integration
Dynamic Lookup in Informatica Cloud (IICS)
A Dynamic lookup is helpful when you are using the target also as a lookup object in the same mapping and the source data contains duplicate primary keys.
HOW TO: Parameterize Source and Target Connections in Informatica Cloud (IICS)?
The connections in IICS CDI can be parameterized at mapping level which needs to be resolved at MCT level. But you can override the values at MCT level using parameter file.
HOW TO: Pass data from one Mapping Task to another in Informatica Cloud (IICS)?
Informatica Cloud supports passing data from one Mapping Task to another. The data can be passed through a Task flow using IO parameters.
SQL Scenario based Interview Questions
SQL Scenario based Interview Questions and answers with detailed explanation and results.
Shared Sequences in Informatica Cloud (IICS)
Shared Sequences are reusable sequences that can be used with multiple Sequence Generator transformations in Informatica Cloud.
HOW TO: Denormalize data in Informatica Cloud (IICS)?
Denormalization is process of converting rows into columns. Understand how to implement the denormalization of data in Informatica Cloud (IICS) mapping and in Oracle using SQL.
XML vs JSON export in Informatica Cloud (IICS)
Learn how to export the tasks in in different ways in IICS, the differences in the metadata stored in XML and JSON and how to use it to our advantage.