• Success
    Manage your Success Plans and Engagements, gain key insights into your implementation journey, and collaborate with your CSMs
    Success
    Success Accelerators
    Accelerate your Purchase to Value engaging with Informatica Architects for Customer Success
    My Engagements
    All your Engagements at one place
  • Communities
    A collaborative platform to connect and grow with like-minded Informaticans across the globe
    Communities
    Product Communities
    Connect and collaborate with Informatica experts and champions
    Discussions
    Have a question? Start a Discussion and get immediate answers you are looking for
    User Groups
    Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
    Get Started
    Community Guidelines
  • Knowledge Center
    Troubleshooting documents, product guides, how to videos, best practices, and more
    Knowledge Center
    Knowledge Base
    One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
    Support TV
    Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
    Documentation
    Information library of the latest product documents
    Velocity (Best Practices)
    Best practices and use cases from the Implementation team
  • Learn
    Rich resources to help you leverage full capabilities of our products
    Learn
    Trainings
    Role-based training programs for the best ROI
    Certifications
    Get certified on Informatica products. Free, Foundation, or Professional
    Product Learning Paths
    Free and unlimited modules based on your expertise level and journey
    Experience Lounge
    Self-guided, intuitive experience platform for outcome-focused product capabilities and use cases
  • Resources
    Library of content to help you leverage the best of Informatica products
    Resources
    Tech Tuesdays Webinars
    Most popular webinars on product architecture, best practices, and more
    Product Availability Matrix
    Product Availability Matrix statements of Informatica products
    SupportFlash
    Monthly support newsletter
    Support Documents
    Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
    Product Lifecycle
    End of Life statements of Informatica products
    Ideas
    Events
    Change Request Tracking
    Marketplace
| Sign up
Videos → Support Videos → How to Generate Mapping from SQL Query in Data Quality
03:40
8240 Views | 12 Feb 2020
Add to Favorites
Remove from Favorites

How to Generate Mapping from SQL Query in Data Quality

Data Quality Enablement English

This video explains how to create mapping from SQL query in Data Quality

Expertise : Expert

User type: Developer, Administrator

Category : Product Feature, Configuration

Project Phase : Onboard, Configure

Problem Type : Configuration

On-Premises Data Quality

Informatica Support 52/154
How to Create Native Oracle Connection in Informatica
playIcon
05:32

How to Create Native Oracle Connection in Informatica
Finding cost of Invalid Data
playIcon
11:47

Finding cost of Invalid Data
Analyst Rule Builder v10 Overview
playIcon
07:15

Analyst Rule Builder v10 Overview
How to Perform Search Service Cleanup in IDQ
playIcon
03:40

How to Perform Search Service Cleanup in IDQ
How to Identify Job Logs for a Job Run by DIS on a GRID
playIcon
08:09

How to Identify Job Logs for a Job Run by DIS on a GRID
Configuring the Advanced Approval Workflow
playIcon
04:46

Configuring the Advanced Approval Workflow
Scorecard Lineage in Data Quality
playIcon
11:20

Scorecard Lineage in Data Quality
How to Create IDQ Service from Command Line
playIcon
09:41

How to Create IDQ Service from Command Line
How to Generate Parameter File for DIS Workflow
playIcon
07:15

How to Generate Parameter File for DIS Workflow
How to configure Developer client to import Hive table from Kerberized Hive
playIcon
04:51

How to configure Developer client to import Hive table from Kerberized Hive
HOW TO Collect Java based diagnostic files for Developer Client Tool DxT
playIcon
11:54

HOW TO Collect Java based diagnostic files for Developer Client Tool DxT
Migration of Data Quality from 8.6.2 to 9.x
playIcon
10:21

Migration of Data Quality from 8.6.2 to 9.x
Multimedia KB: Migrating from Informatica Data Quality 8.6.2 to Informatica 9.0.1
playIcon
12:17

Multimedia KB: Migrating from Informatica Data Quality 8.6.2 to Informatica 9.0.1
Before EBF - Screen Recording (KB 622077)
playIcon
00:23

Before EBF - Screen Recording (KB 622077)
Configuring Monitoring Console in Data Quality
playIcon
03:17

Configuring Monitoring Console in Data Quality
How to Backup and Restore Model Repository Service (MRS) in IDQ
playIcon
04:27

How to Backup and Restore Model Repository Service (MRS) in IDQ
Creating Web Service in Data Services 9.5
playIcon
05:11

Creating Web Service in Data Services 9.5
How to Create IDQ Service from the Informatica Administrator Console
playIcon
09:19

How to Create IDQ Service from the Informatica Administrator Console
How to Perform Developer Tool Cleanup
playIcon
02:21

How to Perform Developer Tool Cleanup
Monitoring Tool and Hang Scenarios
playIcon
19:48

Monitoring Tool and Hang Scenarios
How to Enable Verbose Data Logging for Mappings in Developer Tool
playIcon
04:44

How to Enable Verbose Data Logging for Mappings in Developer Tool
Profiling and PWH Purge Issues
playIcon
19:43

Profiling and PWH Purge Issues
How to Import OOTB Data Domain in IDA using Developer Client
playIcon
09:51

How to Import OOTB Data Domain in IDA using Developer Client
How to Increase the Heap Size for MRS/DIS and Other IDQ Services
playIcon
09:51

How to Increase the Heap Size for MRS/DIS and Other IDQ Services
How to create Rule specification using Rule builder in Analyst 9.6.x
playIcon
14:04

How to create Rule specification using Rule builder in Analyst 9.6.x
How to Identify Job and Service logs from Server
playIcon
10:05

How to Identify Job and Service logs from Server
AddressDoctor - Configure PreferredScript option
playIcon
08:20

AddressDoctor - Configure PreferredScript option
How To Configure URL Ports in REST Consumer Transformation
playIcon
03:06

How To Configure URL Ports in REST Consumer Transformation
How To Make a GET Call Using REST Consumer Transformation
playIcon
04:03

How To Make a GET Call Using REST Consumer Transformation
Data Quality Address Validation Reference Content (Cycle M and Cycle N)
playIcon
04:26

Data Quality Address Validation Reference Content (Cycle M and Cycle N)
Exception Record Management
playIcon
09:14

Exception Record Management
How to Create an Enterprise Discovery Profile through Analyst Tool in IDQ
playIcon
05:32

How to Create an Enterprise Discovery Profile through Analyst Tool in IDQ
How to Create Dynamic Mapping for S3 Objects
playIcon
06:05

How to Create Dynamic Mapping for S3 Objects
How to create a RULE Specifiaction using Reference table
playIcon
07:10

How to create a RULE Specifiaction using Reference table
How to Perform Data Integration Service Cleanup in IDQ
playIcon
04:21

How to Perform Data Integration Service Cleanup in IDQ
Finding Objects Without Stakeholders in Axon Data Governance
playIcon
01:02

Finding Objects Without Stakeholders in Axon Data Governance
How to Install IDQ Reporting and dashboard Template for Jaspersoft
playIcon
08:29

How to Install IDQ Reporting and dashboard Template for Jaspersoft
How to Configure CMS within a Multi-Node GRID-DIS Environment in Data Quality
playIcon
12:10

How to Configure CMS within a Multi-Node GRID-DIS Environment in Data Quality
How to Configure Reference Data Connection and Audit Tables in IDQ through the Administrator Console
playIcon
04:03

How to Configure Reference Data Connection and Audit Tables in IDQ through the Administrator Console
Getting started on Data profiling
playIcon
11:10

Getting started on Data profiling
Analyst Rule Builder Part II - Additional Features
playIcon
04:19

Analyst Rule Builder Part II - Additional Features
How To View the XML Response in the log using REST Consumer Transformation
playIcon
03:00

How To View the XML Response in the log using REST Consumer Transformation
How to gather DQ application ws log file
playIcon
06:04

How to gather DQ application ws log file
Accessing Flat Files in the Developer Tool
playIcon
06:06

Accessing Flat Files in the Developer Tool
HOW TO: Create profile on XML JSON data
playIcon
16:21

HOW TO: Create profile on XML JSON data
DIS Startup Issue
playIcon
39:05

DIS Startup Issue
How to Configure Argument Ports in REST Consumer Transformation
playIcon
04:10

How to Configure Argument Ports in REST Consumer Transformation
How to Terminate the Workflow in case of Task/Mapping Failure and Send a Notification
playIcon
04:16

How to Terminate the Workflow in case of Task/Mapping Failure and Send a Notification
INFASupport Webinar recording "What's new in IDQ V9.5.x"
playIcon
58:44

INFASupport Webinar recording "What's new in IDQ V9.5.x"
How to Schedule IDQ Jobs using Informatica Data Quality Scheduler
playIcon
04:46

How to Schedule IDQ Jobs using Informatica Data Quality Scheduler
How to View JSON Response in the log using REST Consumer Transformation
playIcon
02:29

How to View JSON Response in the log using REST Consumer Transformation
How to Generate Mapping from SQL Query in Data Quality
playIcon
03:40

How to Generate Mapping from SQL Query in Data Quality
Checking If Workflow Tasks Ran Successfully in the Developer Tool
playIcon
04:16

Checking If Workflow Tasks Ran Successfully in the Developer Tool
How to View Monitoring Statistics and Reports in IDQ
playIcon
06:42

How to View Monitoring Statistics and Reports in IDQ
How to Configure Versioned MRS using SVN
playIcon
04:25

How to Configure Versioned MRS using SVN
Concepts of Router Transformation on IDQ
playIcon
06:30

Concepts of Router Transformation on IDQ
How to Collect Jstack on Developer Tool
playIcon
03:54

How to Collect Jstack on Developer Tool
How To Parse JSON Response Using Data Processor
playIcon
02:05

How To Parse JSON Response Using Data Processor
How to Deploy an Application using Admin Console
playIcon
03:55

How to Deploy an Application using Admin Console
How to Troubleshoot Search Service Performance
playIcon
16:11

How to Troubleshoot Search Service Performance
Saving and Managing Searches in Axon Data Governance
playIcon
01:35

Saving and Managing Searches in Axon Data Governance
How to Deploy an Application using Command Line in Informatica Data Quality
playIcon
05:08

How to Deploy an Application using Command Line in Informatica Data Quality
How to Configure Address Validation in Content Management Service in IDQ
playIcon
06:56

How to Configure Address Validation in Content Management Service in IDQ
How to configure the Monitoring MRS
playIcon
04:03

How to configure the Monitoring MRS
How to Create IDQ Services during Installation (UNIX)
playIcon
09:50

How to Create IDQ Services during Installation (UNIX)
How to use a PlatformLogCollector on Unix Platform
playIcon
09:40

How to use a PlatformLogCollector on Unix Platform
Data Quality Column Patterns
playIcon
07:04

Data Quality Column Patterns
Address Doctor Web Services made easy with soapUI
playIcon
08:06

Address Doctor Web Services made easy with soapUI
How to use AddressDoctor Download Manager?
playIcon
10:47

How to use AddressDoctor Download Manager?
How to Schedule Profile Jobs in Informatica Data Quality
playIcon
03:30

How to Schedule Profile Jobs in Informatica Data Quality
Session on Grid (SONG)
playIcon
13:55

Session on Grid (SONG)
How to enable Snoop trace for JDBC connection in Data Quality
playIcon
05:53

How to enable Snoop trace for JDBC connection in Data Quality
How to Deploy Application Using Developer Tool in Informatica
playIcon
06:08

How to Deploy Application Using Developer Tool in Informatica
How to Configure Workflow Database and Create Content in Data Quality
playIcon
03:48

How to Configure Workflow Database and Create Content in Data Quality
How to Create Versioned MRS using GIT
playIcon
05:47

How to Create Versioned MRS using GIT
How to Troubleshoot Analyst Service Startup Issues
playIcon
23:18

How to Troubleshoot Analyst Service Startup Issues
Multimedia KB: Introduction to Content set in Data Quality 9.1
playIcon
07:19

Multimedia KB: Introduction to Content set in Data Quality 9.1
After EBF 17258 - Screen Recording (KB 622077)
playIcon
00:37

After EBF 17258 - Screen Recording (KB 622077)
How To Make a Get Call Using a Schema in REST Consumer Transformation
playIcon
04:08

How To Make a Get Call Using a Schema in REST Consumer Transformation
How to Perform Analyst Service Cleanup in IDQ
playIcon
04:45

How to Perform Analyst Service Cleanup in IDQ
How to Make a Get Call and Parse the Data Using REST Consumer Transformation
playIcon
03:54

How to Make a Get Call and Parse the Data Using REST Consumer Transformation
Getting Started with the Unison Search in Axon
playIcon
06:45

Getting Started with the Unison Search in Axon
How To Parse Complex JSON Response Using REST Consumer Transformation
playIcon
04:57

How To Parse Complex JSON Response Using REST Consumer Transformation
How to Join Profile in Informatica Data Quality?
playIcon
04:46

How to Join Profile in Informatica Data Quality?
How to update an Address Doctor license for IDQ
playIcon
03:06

How to update an Address Doctor license for IDQ
Data Quality Content Installation
playIcon
09:58

Data Quality Content Installation
Integration Service on Grid
playIcon
50:39

Integration Service on Grid
How to migrate Data Quality scorecards
playIcon
03:37

How to migrate Data Quality scorecards
How to Perform Content Management Service Cleanup in IDQ
playIcon
03:56

How to Perform Content Management Service Cleanup in IDQ
How to Create Rest Web Service from Developer Client
playIcon
11:11

How to Create Rest Web Service from Developer Client
How to Create a Customized Data Object in Developer Tool in IDQ
playIcon
03:59

How to Create a Customized Data Object in Developer Tool in IDQ
How to use AddressDoctor Cloud with SOAPui
playIcon
06:24

How to use AddressDoctor Cloud with SOAPui
How to: Bulk Update the Business Terms in Data Quality 9 6
playIcon
13:17

How to: Bulk Update the Business Terms in Data Quality 9 6
Introduction to Scheduler Service
playIcon
07:25

Introduction to Scheduler Service
How to create a Rule Specifiction that validates product Information
playIcon
09:19

How to create a Rule Specifiction that validates product Information
Batch, InterActive Fastcompletion in AddressDoctor
playIcon
11:31

Batch, InterActive Fastcompletion in AddressDoctor
Hang Analysis - How to Troubleshoot a Hang
playIcon
21:03

Hang Analysis - How to Troubleshoot a Hang
How to Backup and Restore Model Repository Service in IDQ through Command Line
playIcon
07:58

How to Backup and Restore Model Repository Service in IDQ through Command Line
Mapping Failure on DIS
playIcon
08:53

Mapping Failure on DIS
How to get started with the AV-transformation within Informatica 9.6.1
playIcon
10:16

How to get started with the AV-transformation within Informatica 9.6.1
How to download Address Doctor country files
playIcon
02:36

How to download Address Doctor country files
How to Configure Profile Warehouse Content in Data Quality
playIcon
03:34

How to Configure Profile Warehouse Content in Data Quality
How to Troubleshoot Job Performance Issues in IDQ
playIcon
19:54

How to Troubleshoot Job Performance Issues in IDQ
Developer Workflow in Data Quality 9.5.0
playIcon
07:27

Developer Workflow in Data Quality 9.5.0
How to Perform Scheduler Service Cleanup in IDQ
playIcon
03:05

How to Perform Scheduler Service Cleanup in IDQ
How to Create IDQ Service from Installer in Windows
playIcon
06:37

How to Create IDQ Service from Installer in Windows
How To Configure Email Service in Data Quality
playIcon
05:47

How To Configure Email Service in Data Quality
How to create JDBC connection in Informatica Data Quality
playIcon
06:20

How to create JDBC connection in Informatica Data Quality
Domain Discovery Profile in Data Explorer 9.5
playIcon
08:41

Domain Discovery Profile in Data Explorer 9.5
How to Configure SQL Server Connection in IDQ (Linux)
playIcon
05:06

How to Configure SQL Server Connection in IDQ (Linux)
How to Create and Run a Profile using Developer Tool
playIcon
06:20

How to Create and Run a Profile using Developer Tool
How to Validate and Enrich Global Telephone Numbers with Informatica Cloud Data Quality
playIcon
03:39

How to Validate and Enrich Global Telephone Numbers with Informatica Cloud Data Quality
How to Create and Use Parameter Set in IDQ
playIcon
04:03

How to Create and Use Parameter Set in IDQ
How to Configure a Parser and Use in a Mapping Informatica Cloud Data Quality
playIcon
05:53

How to Configure a Parser and Use in a Mapping Informatica Cloud Data Quality
How to Verify Emails with Informatica Cloud Data Quality
playIcon
03:48

How to Verify Emails with Informatica Cloud Data Quality
Data Quality for Data Integrations and Data Migrations
playIcon
16:01

Data Quality for Data Integrations and Data Migrations
How to configure DIS to run on GRID
playIcon
06:31

How to configure DIS to run on GRID
How to Update Parameter Set Entries in Application in IDQ using infacmd Command Line
playIcon
03:37

How to Update Parameter Set Entries in Application in IDQ using infacmd Command Line
How to Profile an Oracle Table in Informatica Cloud Data Quality
playIcon
08:17

How to Profile an Oracle Table in Informatica Cloud Data Quality
How to Create a Data Quality Scorecard with Informatica Cloud Data Quality
playIcon
07:02

How to Create a Data Quality Scorecard with Informatica Cloud Data Quality
How to Import OOTB Data Domains using infacmd Command Line in IDQ
playIcon
09:50

How to Import OOTB Data Domains using infacmd Command Line in IDQ
Preloading AV Reference Files in IDQ
playIcon
02:31

Preloading AV Reference Files in IDQ
Creating a Reference Table using a Flatfile in the Analyst Tool
playIcon
03:30

Creating a Reference Table using a Flatfile in the Analyst Tool
How to Create a Snowflake Connection from the Command Line in Data Quality
playIcon
04:29

How to Create a Snowflake Connection from the Command Line in Data Quality
How to Configure High Availability for Data Integration Service
playIcon
05:39

How to Configure High Availability for Data Integration Service
Element Input Status in AV V5
playIcon
02:25

Element Input Status in AV V5
How to Read from ADLS gen2 with Gzip Compression Format in IDQ
playIcon
03:35

How to Read from ADLS gen2 with Gzip Compression Format in IDQ
How to Make a POST Call using Rest Web Service Consumer Transformation in IDQ
playIcon
04:51

How to Make a POST Call using Rest Web Service Consumer Transformation in IDQ
How to Run Profiles/Scorecards using Operating System Profiles (OSP) from Analyst Tool
playIcon
03:05

How to Run Profiles/Scorecards using Operating System Profiles (OSP) from Analyst Tool
How to Configure Operating System Profiles(OSP) in Data Quality
playIcon
07:59

How to Configure Operating System Profiles(OSP) in Data Quality
How to Create a Data Integration Service by INFACMD Command from Server and Admin Console
playIcon
08:54

How to Create a Data Integration Service by INFACMD Command from Server and Admin Console
How to Generate Informatica Log Files using the Command Line
playIcon
04:17

How to Generate Informatica Log Files using the Command Line
How to Add/Delete Users/groups in Informatica Domain
playIcon
07:15

How to Add/Delete Users/groups in Informatica Domain
DualAddress Priority Parameter in AV V5
playIcon
02:49

DualAddress Priority Parameter in AV V5
How to Check the Command Line Arguments and VM Arguments Picked by the Developer Client Tool in IDQ
playIcon
02:07

How to Check the Command Line Arguments and VM Arguments Picked by the Developer Client Tool in IDQ
Data Profiling: Modes of Run
playIcon
05:35

Data Profiling: Modes of Run
How to Apply Patch to Fix Missing Country ISO2
playIcon
01:25

How to Apply Patch to Fix Missing Country ISO2
How to Perform MRS Reindexing
playIcon
03:16

How to Perform MRS Reindexing
Standard Data Quality Rules - Part 2
playIcon
05:25

Standard Data Quality Rules - Part 2
How to Enable Verbose Data Logging for Deployed Mapping from Admin Console
playIcon
03:20

How to Enable Verbose Data Logging for Deployed Mapping from Admin Console
How to Collect Different System Level Diagnostic Information on Linux
playIcon
02:17

How to Collect Different System Level Diagnostic Information on Linux
How to Rollback Country ISO2 Patch to Fix Performance Issues
playIcon
01:51

How to Rollback Country ISO2 Patch to Fix Performance Issues
Introduction to Informatica Data Quality
playIcon
03:04

Introduction to Informatica Data Quality
How to Check AV Reference Details in GetConfig in IDQ
playIcon
01:38

How to Check AV Reference Details in GetConfig in IDQ
Installation of Informatica Developer Tool
playIcon
06:01

Installation of Informatica Developer Tool
Element Results Status in AV V5
playIcon
02:08

Element Results Status in AV V5
How to Import Selective Object from MRS using Control Files (Data object, Mapping, Reference table)
playIcon
09:56

How to Import Selective Object from MRS using Control Files (Data object, Mapping, Reference table)
Labeler Transformation in Informatica Data Quality
playIcon
09:00

Labeler Transformation in Informatica Data Quality
How to Collect PMStack on the Core Files
playIcon
04:42

How to Collect PMStack on the Core Files
How to Configure Alerts for the Domain
playIcon
08:04

How to Configure Alerts for the Domain
IDQ Lifecycle
playIcon
03:53

IDQ Lifecycle
Case Converter Transformation in IDQ
playIcon
05:33

Case Converter Transformation in IDQ
How to Export Selective Object from MRS using Control Files (Data object, Mapping, Reference table)
playIcon
07:24

How to Export Selective Object from MRS using Control Files (Data object, Mapping, Reference table)
How to Enable the HSTS (HTTP Strict Transport Security) in Informatica
playIcon
03:38

How to Enable the HSTS (HTTP Strict Transport Security) in Informatica
Back To Top

Success

Link Copied to Clipboard