HOW TO: Remove Duplicates in Snowflake?
Learn different ways to remove duplicate records from a Snowflake table using SWAP WITH and INSERT OVERWRITE commands.
Concepts
Partitioning target S3 files in Informatica Cloud (IICS)
IICS supports creating multiple target S3 files by configuring a single target transformation using Distribution Column.
IICS Amazon S3 Connection – Temporary Credentials Duration
Learn how to fix ExpiredToken error while working with IICS Amazon S3 Connection using Temporary Credentials Duration.
IICS Amazon S3 v2 Connector – Authenticate via AssumeRole
Learn how to create Amazon S3 v2 Connection in Informatica Cloud using Temporary security credentials via AssumeRole
IICS Amazon S3 v2 Connector – IAM Authentication
Learn how to create Amazon S3 v2 Connection in Informatica Cloud with IAM Authentication method using IAM Roles.
IICS Amazon S3 v2 Connector – Basic Authentication
Learn how to create Amazon S3 v2 Connection in Informatica Cloud with Basic Authentication method using Access Keys.
Snowflake Resource Monitors
Snowflake Resource Monitors assist in cost management and prevent unforeseen credit usage caused by operating warehouses.
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.
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.