Top Informatica Cloud Courses in Udemy
A curated list of top Informatica Cloud courses available on Udemy covering various Informatica Service offerings.
Top Informatica Cloud (IICS) Interview questions
A complete collection of top Informatica Cloud(IICS) interview questions
How to read metadata in Informatica Cloud (IICS)?
Ultimate guide to understand how to read metadata in Informatica Cloud
MIN_BY and MAX_BY Functions in Snowflake
MIN_BY and MAX_BY are aggregate functions in Snowflake that calculate the minimum or maximum value of a column and return the value of another column in that row.
HOW TO: Drop a Column from a Snowpark DataFrame?
Learn how to drop a column from a Snowflake Snowpark DataFrame using drop() method with examples.
HOW TO: Add a New Column to a Snowpark DataFrame?
Learn multiple ways to add a new column to a Snowpark DataFrame that includes adding a column with default value, based on a condition, and adding multiple columns with examples.
HOW TO: Remove Duplicates in a Snowpark DataFrame?
The dropDuplicates() method in Snowpark returns a new DataFrame with all duplicate rows removed.
CASE Statement in Snowflake Snowpark
Learn how a CASE statement can be constructed in Snowflake Snowpark using when() and otherwise() methods.
INSERT and Multi-Table Inserts in Snowflake
Learn how to perform Insert, Multi-Row Insert and Multi-Table Inserts in Snowflake using INSERT and INSERT ALL statements.
Common Table Expressions (CTEs) in Snowflake
A Common Table Expression (CTE) in Snowflake is a named subquery used within the execution scope of the query in which it is specified.
HOW TO: Parameterize Expression Transformation in Informatica Cloud (IICS) ?
Expression transformations can be fully parameterized in Informatica Cloud mappings, allowing fields to be created at the mapping task level.
Creating Snowflake Iceberg tables using AWS Glue as Catalog
An Externally Managed Iceberg Table is a table where an external system such as AWS Glue manages both the table data and metadata.
HOW TO: Create Snowflake Iceberg Tables?
A Snowflake Iceberg table Snowflake employs the Apache Iceberg format for organizing and storing data within the Snowflake data warehouse environment.