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

Concepts

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
Mapplets in Informatica Cloud

Mapplets in Informatica Cloud (IICS)

November 26, 2023October 1, 2023

Mapplets are a powerful feature to build reusable transformation logic and use across multiple mappings in Informatica Cloud.

Categories Advanced Concepts, Concepts, Informatica
Add Filename field for S3 Flat Files in Informatica Cloud

HOW TO: Add Currently Processed Filename field for Flat Files using Amazon S3 v2 connection in IICS?

November 26, 2023September 13, 2023

Learn how to add Currently Processed Filename field for Flat Files using Amazon S3 v2 connection in Informatica Cloud.

Categories Concepts, Informatica, Real-time Scenarios
Informatica Cloud Advanced Serverless

Informatica Cloud Advanced Serverless

November 26, 2023September 2, 2023

Advanced Serverless is a fully managed serverless deployment solution with no clusters or software to manage with high-performance and built-in elasticity.

Categories Concepts, Informatica, Secure Agent
Informatica Cloud Data Integration Elastic

Informatica Cloud Data Integration Elastic (CDI-E)

November 26, 2023August 14, 2023

Informatica Cloud Data Integration Elastic (CDI-E) enables you to process your jobs on advanced Spark serverless compute engine.

Categories Concepts, Informatica, Secure Agent
Older posts
Page1 Page2 … Page13 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

  • 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
  • Data Load using COPY INTO Command in Snowflake
    Data Load using COPY INTO Command in Snowflake
  • Executing External API calls from Snowflake
    HOW TO: Make External API calls from Snowflake?

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