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
Overview of Snowflake Role Based Access Control
Learn various system define roles in Snowflake, their purpose and how you can create custom roles and Role Hierarchy.
HOW TO: Implement SCD Type-2 Mapping in Informatica Cloud (IICS)
A complete guide to implementing SCD Type-2 mapping in Informatica Cloud Data Integration
HOW TO: Implement SCD Type-1 Mapping in Informatica Cloud (IICS)
A complete guide to implementing SCD Type-1 mapping in Informatica Cloud Data Integration
Snowflake Virtual Warehouses
A Virtual warehouse is a cluster of compute resources which provides required resources such as CPU, memory, and temporary storage in Snowflake.
Snowflake Micro-Partitions & Data Clustering
Learn about Snowflake Micro-partitioning method and how the storage can be organized using Data Clustering in Snowflake.