Skip to content
ThinkETL

ThinkETL

  • Home
  • Interview Questions
  • Certification
  • Informatica
    • Advanced Concepts
    • Automation
    • Certification
    • Connectors
    • Interview Questions
    • Real-time Scenarios
    • Rest API
    • Secure Agent
    • Slowly Changing Dimensions
    • Taskflows
    • Transformations
  • Snowflake
    • Access Control and Security
    • Data Loading and Handling
    • Data Management and Utilities
    • Query and Performance Optimization
    • Snowflake REST API
    • Snowpark
    • Snowpipe
    • Stored Procedures
  • Catalogue
  • Courses
Introduction of Snowflake Snowpark

Introduction to Snowflake Snowpark for Python

February 25, 2024January 2, 2024

The Snowpark is an intuitive library that offers an API for querying and processing data at scale in Snowflake.

Categories Snowflake, Snowpark
DATEDIFF Function in Snowflake

DATEDIFF Function in Snowflake: Calculate the difference between two dates

December 24, 2023

The DATEDIFF function in Snowflake facilitates the calculation of the difference between two date, time, or timestamp values.

Categories Data Management and Utilities, Snowflake
Greatest and Least functions in Snowflake

GREATEST and LEAST Functions in Snowflake

December 16, 2023

The GREATEST function in Snowflake retrieves the largest value whereas the LEAST function returns the smallest value from a list of expressions.

Categories Data Management and Utilities, Snowflake
Snowflake Dynamic Tables

Snowflake Dynamic Tables: Change Data Capture Simplified

November 10, 2024December 8, 2023

Snowflake Dynamic Tables track the changes in the query data specified and refresh the materialized results incrementally through an automated process.

Categories Data Management and Utilities, Snowflake
QUALIFY clause in Snowflake

QUALIFY in Snowflake: Filter Window Functions

November 26, 2023November 5, 2023

QUALIFY clause in a SELECT statement allows you to filter query results of Window functions within the same query.

Categories Concepts, Data Management and Utilities, Snowflake
GROUP BY ALL in Snowflake

GROUP BY ALL in Snowflake

January 29, 2024November 5, 2023

The GROUP BY ALL clause is similar to GROUP BY clause except that it automatically include all non-aggregate items in the SELECT clause for grouping.

Categories Concepts, Data Management and Utilities, Snowflake
Rank Transformation in Informatica Cloud

Rank Transformation in Informatica Cloud (IICS)

November 26, 2023October 24, 2023

Rank Transformation helps in identifying largest or smallest set of values in a group of data by filtering the data and ranking the values.

Categories Concepts, Informatica, Transformations

SQL Transformation: Query Mode in Informatica Cloud (IICS)

November 26, 2023October 22, 2023

A SQL Transformation can be used to process a SQL query either using a “Saved Query” or a User “Entered Query”.

Categories Concepts, Informatica, Transformations
SQL Transformation in Informatica Cloud

SQL Transformation: Call Stored Procedures in Informatica Cloud (IICS)

November 26, 2023October 15, 2023

SQL Transformation in Informatica Cloud is used to call a Stored Procedure or Function, or execute SQL queries midstream in a mapping pipeline.

Categories Concepts, Informatica, Transformations
User Defined Functions in Informatica Cloud

User-Defined Functions (UDFs) in Informatica Cloud (IICS)

November 26, 2023October 8, 2023

User-defined functions allows you to create and store complex transformation logic using built-in functions and reuse them across mappings.

Categories Advanced Concepts, Concepts, Informatica
Older posts
Newer posts
← Previous Page1 … Page4 Page5 Page6 … Page19 Next →

Take up the Quiz

  • IICS Interview Questions Quiz-1
  • IICS Interview Questions Quiz-2
  • IICS Interview Questions Quiz-3
  • IICS Interview Questions Quiz-4
  • IICS Transformations Quiz-1
  • IICS Transformations Quiz-2
  • IICS Taskflows Quiz
  • IICS Expression Macros Quiz
  • IICS Certification Practice Test
  • SQL Analytic Functions Quiz
Informatica Cloud Professional Certification Practice Tests
Deal extended: Courses Up To 85% Off

Subscribe

Informatica Cloud Data Integration - Automation Project

Recent Posts

  • Snowflake Cortex AISQL Functions
    Snowflake Cortex AISQL Functions
  • Event Tables in Snowflake
    Event Tables in Snowflake
  • Data Unloading using COPY INTO Command in Snowflake
    Data Unloading using COPY INTO Command in Snowflake
  • Snowflake Directory Tables
    Snowflake Directory Tables: Query and Manage Staged Files
  • Snowflake File URLs Securely Access & Share Staged Files
    Snowflake File URLs: Securely Access and Share Staged Files

About ThinkETL

ThinkETL is your go to resource for learning Informatica Cloud and Snowflake Concepts, Interview preparation and Automation Ideas and strategies that work.

Pages

  • About
  • Catalogue
  • Certification
  • Contact
  • Courses
  • Privacy Policy
  • Subscribe
  • Terms of Use
  • Automation
  • Certification
  • Concepts
  • Informatica
  • Interview Questions
  • Snowflake

Follow Us

Copyright © 2023 ThinkETL