Dynamic Mapping Task in Informatica Cloud (IICS)
A Dynamic Mapping Task lets you create and group multiple jobs based on the data flow logic defined in a parameterized mapping.
Concepts
Snowflake Information Schema
The INFORMATION_SCHEMA is a read-only schema available automatically under each database. It stores metadata of all the objects built under the database.
HOW TO: Read Excel Files in Informatica Cloud (IICS)?
Microsoft Excel Connector is an Add-On Connector that let you read data from multiple worksheets of an Excel source file.
File Processor Connector: Transfer files between SFTP Server and Local System in IICS
File Processor Connector in IICS lets you securely transfer files from one location to another regardless of size and location.
FTP/SFTP connection: Read files from remote server in Informatica Cloud (IICS)
FTP/SFTP Connection in Informatica Cloud enables you to access source and target files present in a remote sever.
HOW TO: Load and Query JSON data in Snowflake?
Snowflake supports loading JSON data in database tables and allows querying data along with flattening it into a columnar structure.
HOW TO: Use Informatica Cloud (IICS) Debugger
Informatica Cloud Debugger helps you preview data to troubleshoot errors at any point in a mapping, even as you build it.
Snowflake File Formats
Snowflake File format simplifies the process of accessing the staged data and streamlines data loading/unloading in database tables.
HOW TO: Implement SCD Type-6 Mapping in Informatica Cloud (IICS)
A complete guide to implementing SCD Type-6 mapping in Informatica Cloud Data Integration
HOW TO: Implement SCD Type-3 Mapping in Informatica Cloud (IICS)
A complete guide to implementing SCD Type-3 mapping in Informatica Cloud Data Integration