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.
Informatica Cloud Automation: Building Impact Analysis Tool
A complete guide to building Informatica Cloud Automation tool which automates the process of Impact analysis in IICS.
Joiner Transformation in Informatica Cloud (IICS)
Joiner Transformation is used to join data coming from two different data streams based on the condition and the join type defined in Informatica Cloud
Normalizer Transformation in Informatica Cloud (IICS)
Normalizer Transformation transforms one incoming row that contains multiple-occurring data into multiple output rows in Informatica Cloud