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
concepts
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.
Flow Run Order: Target Load Plan in Informatica Cloud (IICS)
Learn how to configure Flow Run Order in IICS to specify the order in which data Integration service process the data flows in a mapping
HOW TO: Handle Daylight Saving Time changes in Informatica Cloud (IICS)
Learn how to calculate daylight saving time start and end dates in a given year in Informatica Cloud along with common issue with DST and how to solve them.
How to trigger IICS Tasks from Command Line using RunAJob Utility?
Understand how to trigger IICS tasks from command line using RunAJob utility and its requirements and setup process.
Updating NULL values in Salesforce from Informatica Cloud (IICS)
Learn different ways to update NULL values in Salesforce from Informatica Cloud. Understand how to use #N/A to update NULL values in Salesforce.
How to create JSON file in Informatica Cloud (IICS)?
Learn how to create a JSON file in IICS using Hierarchy Builder transformation. Understand how to prepare source data to create JSON file
How to read JSON file in Informatica Cloud (IICS) ?
Learn how to read a JSON file in IICS using Hierarchy Parser transformation. Understand Hierarchical Schema and multiple output groups in JSON