| Sign up
Success Portal → Videos → Support Videos → HOW TO: Use SQL Transformation with Databricks Delta connector in IICS/IDMC
05:23
45 Views | 22 Jul 2026
Add to Favorites
Remove from Favorites

HOW TO: Use SQL Transformation with Databricks Delta connector in IICS/IDMC

This video explains how to use SQL Transformation with Databricks Delta connector in IICS/IDMC.

References:
Databricks Docs: https://docs.databricks.com/

Informatica Docs: https://docs.informatica.com/integration-cloud/data-integration-connectors/current-version/databricks-connector/mappings-for-databricks/sql-transformation.html




Expertise- Beginner, Intermediate
User type: Administrator, Developer
Category: Configuration

Informatica Support 0/73
Build Efficient, High-performance Data Pipelines with IICS
playIcon
30:27

Build Efficient, High-performance Data Pipelines with IICS
Introduction to SFTP Service in IICS
playIcon
12:21

Introduction to SFTP Service in IICS
Continuous Integration using IICS Asset Management CLI, GIT CLI and Azure DevOps
playIcon
04:56

Continuous Integration using IICS Asset Management CLI, GIT CLI and Azure DevOps
Introducing Informatica Intelligent Cloud Services
playIcon
07:21

Introducing Informatica Intelligent Cloud Services
Creating a Microsoft SQL Server Connection in Administrator
playIcon
03:11

Creating a Microsoft SQL Server Connection in Administrator
Introducing IICS for Data Warehouse, Lake, and App Modernization
playIcon
29:21

Introducing IICS for Data Warehouse, Lake, and App Modernization
IICS for PowerCenter Developers: Running a Mapping without a Session
playIcon
01:57

IICS for PowerCenter Developers: Running a Mapping without a Session
IICS Mass Ingestion Streaming using REST V2 Source
playIcon
09:20

IICS Mass Ingestion Streaming using REST V2 Source
Informatica Intelligent Cloud Services (IICS) for Data Warehouse, Lake, and App Modernization
playIcon
30:53

Informatica Intelligent Cloud Services (IICS) for Data Warehouse, Lake, and App Modernization
IICS for PowerCenter Developers: Similarities and Differences in Mapping Transformations
playIcon
03:18

IICS for PowerCenter Developers: Similarities and Differences in Mapping Transformations
How to Configure Trusted IP Ranges for IICS Org
playIcon
05:16

How to Configure Trusted IP Ranges for IICS Org
Creating a Salesforce Connection in Administrator
playIcon
03:19

Creating a Salesforce Connection in Administrator
Monitor Overview
playIcon
03:51

Monitor Overview
How to Setup a Master/Sub Organization in IICS
playIcon
10:49

How to Setup a Master/Sub Organization in IICS
How to Configure Blackout period in IICS
playIcon
05:05

How to Configure Blackout period in IICS
Administration - Users, Groups, and Permissions
playIcon
03:13

Administration - Users, Groups, and Permissions
Azure Key Vault Integration with IICS
playIcon
45:58

Azure Key Vault Integration with IICS
How to Create a Connection using Key Based Authentication in IICS
playIcon
04:47

How to Create a Connection using Key Based Authentication in IICS
How to Use 'RunAJob' Utility in IICS
playIcon
04:58

How to Use 'RunAJob' Utility in IICS
Installing JDBC and ODBC Drivers for MySQL Connector on Windows (NO VOICE)
playIcon
03:06

Installing JDBC and ODBC Drivers for MySQL Connector on Windows (NO VOICE)
How to Export and Import Assets in IICS
playIcon
03:47

How to Export and Import Assets in IICS
Continuous Integration using IICS asset management CLI and Jenkins Pipeline
playIcon
08:54

Continuous Integration using IICS asset management CLI and Jenkins Pipeline
Installing JDBC and ODBC Drivers for MySQL Connector on Linux (NO VOICE)
playIcon
05:14

Installing JDBC and ODBC Drivers for MySQL Connector on Linux (NO VOICE)
Administration - Upgrades in IICS
playIcon
03:01

Administration - Upgrades in IICS
Workflow Manager - Workflow Equivalent in IICS
playIcon
05:38

Workflow Manager - Workflow Equivalent in IICS
PowerCenter to IICS Basics - Component Architecture
playIcon
03:20

PowerCenter to IICS Basics - Component Architecture
Workflow Manager - Session Equivalent in IICS
playIcon
02:30

Workflow Manager - Session Equivalent in IICS
Mass Ingest Data to Feed your Data Warehouses and Lakes with IICS
playIcon
29:45

Mass Ingest Data to Feed your Data Warehouses and Lakes with IICS
IICS for PowerCenter Developers: How do Folders Work in IICS
playIcon
04:20

IICS for PowerCenter Developers: How do Folders Work in IICS
How to create an IICS Organization
playIcon
06:01

How to create an IICS Organization
How to Use Aggregator Transformation in Informatica Cloud Mapping Designer
playIcon
15:35

How to Use Aggregator Transformation in Informatica Cloud Mapping Designer
How to Re-register an Existing Informatica Cloud Secure Agent from One IICS Org to Another
playIcon
13:39

How to Re-register an Existing Informatica Cloud Secure Agent from One IICS Org to Another
Creating a Google BigQuery Connection in Administrator
playIcon
02:17

Creating a Google BigQuery Connection in Administrator
Administration - Adding Connectors and Packages in IICS
playIcon
02:04

Administration - Adding Connectors and Packages in IICS
User Roles, User Groups, and Permissions in IICS
playIcon
03:11

User Roles, User Groups, and Permissions in IICS
How to Import and Export using IICS Developer APIs
playIcon
06:22

How to Import and Export using IICS Developer APIs
How to Change SAML Username in IDMC Console
playIcon
03:46

How to Change SAML Username in IDMC Console
How to Use Joiner Transformation in Informatica Cloud Mapping Designer
playIcon
09:54

How to Use Joiner Transformation in Informatica Cloud Mapping Designer
How to use Router Transformation in IICS
playIcon
11:47

How to use Router Transformation in IICS
How to Retrieve Activity Log Entries using IICS REST API
playIcon
09:54

How to Retrieve Activity Log Entries using IICS REST API
Overview of the Explore Page in Administrator
playIcon
04:17

Overview of the Explore Page in Administrator
CDI Functionality
playIcon
07:23

CDI Functionality
Continuous Integration using IICS asset management CLI and Jenkins Pipeline
playIcon
07:29

Continuous Integration using IICS asset management CLI and Jenkins Pipeline
How to Generate Swagger File in IICS
playIcon
04:57

How to Generate Swagger File in IICS
How to Generate IICS Swagger File
playIcon
14:10

How to Generate IICS Swagger File
Creating an Amazon Redshift V2 Connection in Administrator
playIcon
03:11

Creating an Amazon Redshift V2 Connection in Administrator
IDMC Self Healing AI Agent - Leveraging AI Agent Engineering
playIcon
14:48

IDMC Self Healing AI Agent - Leveraging AI Agent Engineering
How Guy Carpenter brought CICD automation to their iPaaS using Azure DevOps
playIcon
01:01:16

How Guy Carpenter brought CICD automation to their iPaaS using Azure DevOps
Creating a Google Cloud Storage V2 Connection in Administrator
playIcon
03:03

Creating a Google Cloud Storage V2 Connection in Administrator
Connecting to Microsoft SQL Server Hosted on AWS in Administrator
playIcon
02:45

Connecting to Microsoft SQL Server Hosted on AWS in Administrator
Administrator Overview
playIcon
04:17

Administrator Overview
ODBC Tracing in IDMC
playIcon
09:19

ODBC Tracing in IDMC
Administration of Google Drive Connector: Creating OAuth
playIcon
05:35

Administration of Google Drive Connector: Creating OAuth
How to Use Sorter Transformation in IICS
playIcon
03:08

How to Use Sorter Transformation in IICS
Setting Up a Serverless Runtime Environment with AWS CloudFormation in Administrator
playIcon
05:06

Setting Up a Serverless Runtime Environment with AWS CloudFormation in Administrator
IPU Metering and Dashboard in IICS
playIcon
30:50

IPU Metering and Dashboard in IICS
How to Create Azure Blob V3 Connection in IICS
playIcon
02:48

How to Create Azure Blob V3 Connection in IICS
Creating a MySQL Connection in Administrator
playIcon
03:03

Creating a MySQL Connection in Administrator
How to Capture Strace for IICS Tasks
playIcon
05:14

How to Capture Strace for IICS Tasks
Installing JDBC and ODBC Drivers for MySQL Connector on Windows (NO VOICE)
playIcon
03:13

Installing JDBC and ODBC Drivers for MySQL Connector on Windows (NO VOICE)
How to perform Import and Export in IICS
playIcon
04:14

How to perform Import and Export in IICS
SDLC using IICS REST API
playIcon
11:19

SDLC using IICS REST API
Creating a Kafka Connection in Administrator
playIcon
01:43

Creating a Kafka Connection in Administrator
Creating a Google BigQuery V2 Connection in Administrator
playIcon
03:48

Creating a Google BigQuery V2 Connection in Administrator
IICS for PowerCenter Developers: How to Navigate IICS
playIcon
04:58

IICS for PowerCenter Developers: How to Navigate IICS
Creating an AWS RDS MySQL Connection in Administrator
playIcon
03:29

Creating an AWS RDS MySQL Connection in Administrator
IICS Services
playIcon
04:10

IICS Services
Creating a REST V2 Connection in Administrator
playIcon
04:00

Creating a REST V2 Connection in Administrator
How to Create SharePoint Online Connector in IDMC through Microsoft EntraID Authentication
playIcon
15:44

How to Create SharePoint Online Connector in IDMC through Microsoft EntraID Authentication
Best Practices for Provisioning Organizations in IDMC Administrator
playIcon
02:13

Best Practices for Provisioning Organizations in IDMC Administrator
Viewing and Downloading Metering Reports in IDMC Administrator
playIcon
01:54

Viewing and Downloading Metering Reports in IDMC Administrator
Creating and Managing Sub-organizations in Administrator
playIcon
02:43

Creating and Managing Sub-organizations in Administrator
新しい IDMC サービスヘルスダッシュボード「Pulse」の紹介
playIcon
05:18

新しい IDMC サービスヘルスダッシュボード「Pulse」の紹介
Back To Top

Success

Link Copied to Clipboard