• 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 → Concatenate Two Fields in the Developer Tool
04:20
7244 Views | 03 May 2013
Add to Favorites
Remove from Favorites

Concatenate Two Fields in the Developer Tool

Learn how to concatenate two fields when you want to combine data from two different fields into one field in the Developer tool. Use the CONCAT function in an Expression transformation to concatenate the fields.

In this demo, we will concatenate the first name and last name of each customer to create the full name.

On-Premises Data Integration

Informatica Support 35/68
PowerCenter resource load for Metadata Manager
playIcon
07:48

PowerCenter resource load for Metadata Manager
Parameterize Connections in the Developer Tool
playIcon
08:31

Parameterize Connections in the Developer Tool
Informatica Big Data Edition: Data Integration on Hadoop
playIcon
12:52

Informatica Big Data Edition: Data Integration on Hadoop
Informatica Node HeapSize Setting
playIcon
03:32

Informatica Node HeapSize Setting
Connect to the Repository in the Developer Tool
playIcon
01:43

Connect to the Repository in the Developer Tool
How to Switch from Hub Overview Diagram to Welcome Page on User Login in DIH
playIcon
03:05

How to Switch from Hub Overview Diagram to Welcome Page on User Login in DIH
INFASupport Webinars : Understanding SSL Secure Socket Layer HTTPS with PowerCenter 960
playIcon
01:02:13

INFASupport Webinars : Understanding SSL Secure Socket Layer HTTPS with PowerCenter 960
Creating an Informatica Platform resource
playIcon
06:58

Creating an Informatica Platform resource
Performing a Lookup in the Developer Tool
playIcon
04:16

Performing a Lookup in the Developer Tool
Introducing Informatica Intelligent Cloud Services Data Integration
playIcon
04:35

Introducing Informatica Intelligent Cloud Services Data Integration
Making a Decision in a Workflow in the Developer Tool
playIcon
06:39

Making a Decision in a Workflow in the Developer Tool
Monitoring Objects - H2L video
playIcon
03:53

Monitoring Objects - H2L video
Create and Use a Reusable Transformation in the Developer Tool
playIcon
06:46

Create and Use a Reusable Transformation in the Developer Tool
Infasupport Webinar recording : What Makes PowerExchange CDC Workflows Different
playIcon
01:03:27

Infasupport Webinar recording : What Makes PowerExchange CDC Workflows Different
How to read/write files to HDFS in Informatica Data Services
playIcon
10:42

How to read/write files to HDFS in Informatica Data Services
Configuring MFT Protocols in B2B DataExchange DX
playIcon
06:59

Configuring MFT Protocols in B2B DataExchange DX
Business Glossary Data Stewardship
playIcon
04:50

Business Glossary Data Stewardship
What does the snooze property for PMPC rules do
playIcon
12:45

What does the snooze property for PMPC rules do
Sort Data - H2L video
playIcon
05:17

Sort Data - H2L video
Integration between Business Glossary and Metadata Manager
playIcon
03:33

Integration between Business Glossary and Metadata Manager
Rule and Data Asset Linking to Business Terms in the Analyst Tool
playIcon
04:05

Rule and Data Asset Linking to Business Terms in the Analyst Tool
Create a Scorecard in Analyst Tool
playIcon
06:17

Create a Scorecard in Analyst Tool
Informatica Big Data Edition: Social Data and Log File Processing on Hadoop
playIcon
06:52

Informatica Big Data Edition: Social Data and Log File Processing on Hadoop
Changes in Catalog view for Metadata manager 10.0
playIcon
06:15

Changes in Catalog view for Metadata manager 10.0
Business Glossary Rich Text and Attachments support for Analyst 10.0
playIcon
09:42

Business Glossary Rich Text and Attachments support for Analyst 10.0
Send an Email from a Workflow in the Developer Tool
playIcon
08:11

Send an Email from a Workflow in the Developer Tool
How to load Erwin Resource Load for Metadata Manager
playIcon
10:59

How to load Erwin Resource Load for Metadata Manager
How to create a PMPC Rule to Alert on Non Responsive Sessions
playIcon
13:40

How to create a PMPC Rule to Alert on Non Responsive Sessions
Loading an Oracle Advanced Security Option support in Metadata Manager
playIcon
06:58

Loading an Oracle Advanced Security Option support in Metadata Manager
INFASupport Webinar Series: An Introduction to achieving high availability through PowerCenter
playIcon
01:28:12

INFASupport Webinar Series: An Introduction to achieving high availability through PowerCenter
Business Glossary Overview
playIcon
05:41

Business Glossary Overview
How to Setup the DIS GRID and CMS Configuration
playIcon
03:58

How to Setup the DIS GRID and CMS Configuration
PowerCenter Express Overview - H2L video
playIcon
06:48

PowerCenter Express Overview - H2L video
How to import data models in Developer Tool
playIcon
05:43

How to import data models in Developer Tool
Concatenate Two Fields in the Developer Tool
playIcon
04:20

Concatenate Two Fields in the Developer Tool
Business Glossary Business Initiative
playIcon
04:37

Business Glossary Business Initiative
Business Glossary Customization
playIcon
04:44

Business Glossary Customization
Informatica Big Data Edition: Data Ingestion into Hadoop
playIcon
09:31

Informatica Big Data Edition: Data Ingestion into Hadoop
Create A Mapping from a Profile - H2L video
playIcon
02:48

Create A Mapping from a Profile - H2L video
Preview Data - H2L video
playIcon
05:18

Preview Data - H2L video
Create and Run a Profile - H2L video
playIcon
05:18

Create and Run a Profile - H2L video
How to use SSGODDBC utility to test the ODBC connectivity for PowerCenter
playIcon
05:17

How to use SSGODDBC utility to test the ODBC connectivity for PowerCenter
Create and Reuse a Mapplet in the Developer Tool
playIcon
06:59

Create and Reuse a Mapplet in the Developer Tool
Informatica Big Data Edition: Data Profiling on Hadoop
playIcon
09:49

Informatica Big Data Edition: Data Profiling on Hadoop
Business Glossary Administration
playIcon
05:12

Business Glossary Administration
Import and Preview a Relational Data Object - H2L video
playIcon
04:44

Import and Preview a Relational Data Object - H2L video
Business Glossary Export and Import changes for Analyst 10.0
playIcon
08:40

Business Glossary Export and Import changes for Analyst 10.0
Fault Mapping Data Services
playIcon
07:09

Fault Mapping Data Services
Generate a Sequence of Numeric Values in the Developer Tool
playIcon
06:12

Generate a Sequence of Numeric Values in the Developer Tool
Business Glossary migration from one environment to another in Metadata Manager
playIcon
05:56

Business Glossary migration from one environment to another in Metadata Manager
How to configure Informatica Data Service JDBC driver for IBM Websphere Application Server
playIcon
10:18

How to configure Informatica Data Service JDBC driver for IBM Websphere Application Server
Informatica MTE-Blaze Archiecture Webinar
playIcon
52:37

Informatica MTE-Blaze Archiecture Webinar
Business Glossary Relationship View
playIcon
04:36

Business Glossary Relationship View
Content Creation in Metadata Manager 10.0
playIcon
08:37

Content Creation in Metadata Manager 10.0
Adding a Rule to a Column Profile in the Developer Tool
playIcon
04:41

Adding a Rule to a Column Profile in the Developer Tool
Join Two Data Sources - H2L video
playIcon
07:02

Join Two Data Sources - H2L video
HOW TO: Display the Entire Process Argument Values in Proactive Monitoring Alerts
playIcon
08:46

HOW TO: Display the Entire Process Argument Values in Proactive Monitoring Alerts
Creating a DB2 ZOS resource in Metadata Manager
playIcon
07:14

Creating a DB2 ZOS resource in Metadata Manager
Access Web Services - H2L video
playIcon
05:11

Access Web Services - H2L video
Informatica Data Services From SAPBI Tool
playIcon
06:32

Informatica Data Services From SAPBI Tool
How to install Data Validation Option
playIcon
05:34

How to install Data Validation Option
PowerCenter Express Marketplace Integration
playIcon
07:17

PowerCenter Express Marketplace Integration
How to preview source and target data in Designer
playIcon
05:05

How to preview source and target data in Designer
Lineage Analysis changes from Metadata Manager 10.0
playIcon
08:16

Lineage Analysis changes from Metadata Manager 10.0
Service creation in Metadata Manager 10
playIcon
09:40

Service creation in Metadata Manager 10
Aggregate Data - H2L video
playIcon
08:34

Aggregate Data - H2L video
Create and Run a Pass-through Mapping - H2L video
playIcon
03:36

Create and Run a Pass-through Mapping - H2L video
Create, Deploy, and Run a Workflow in the Developer Tool
playIcon
09:57

Create, Deploy, and Run a Workflow in the Developer Tool
Back To Top

Success

Link Copied to Clipboard