EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login
Home Data Science Data Science Tutorials Informatica Tutorial Expression Transformation in Informatica
Secondary Sidebar
Informatica Tutorial
  • Basisc
    • What is Informatica
    • Careers In Informatica
    • Informatica Architecture
    • All About Informatica Developer Tool
    • Informatica ETL Tools
    • Normalizer Transformation in Informatica
    • Router Transformation in Informatica
    • Transformations in Informatica
    • Transformations in Informatica with Example
    • Rank Transformation in Informatica
    • Joiner Transformation in Informatica
    • Expression Transformation in Informatica
    • Source Qualifier Transformation
    • Lookup in Informatica
    • Mapping in Informatica
    • Informatica MDM
    • Informatica PowerCenter
    • Informatica Cloud
    • Informatica Scenario Based Interview Questions
    • Informatica Cloud Interview Questions
    • Informatica PowerCenter ETL

Related Courses

Informatica Certification Course

Data Visualization Courses

Cloud Computing Certification Course

Expression Transformation in Informatica

By Priya PedamkarPriya Pedamkar

Expression Transformation in Informatica

Introduction to Expression Transformation in Informatica

Expression Transformation in Informatica is one of the passive transformation features that is used to manipulate row-wise data through the mapping. It accepts data from input ports and processes the record-wise data modification using several operations or functions though the variable ports and output ports. It supports multiple expressions on multiple output ports in an expression transformation that helps in creating the calculated or transformed values. Expression transformation supports dynamic and pass-through ports for data propagation. One of the use cases of expression transformation in Informatica is calculating the retail price of the products based upon the tax rates and the regular sales prices using the price list data.

How to Perform Expression Transformation in Informatica?

Here we will see how to perform expression transformation in Informatica using the Informatica cloud that is the latest offering from Informatica for data integration. Informatica Cloud is software as a service (Saas) that provides a cloud-based platform and functionality to develop data integration solutions.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Given below are the steps to use expression transformation in Informatica.

Step 1: Log in to the Informatica cloud.

The first step for developing data integration through the Informatica cloud is to log into the cloud instance provided by Informatica. Use the credentials to log in to the Informatica cloud environment.

All in One Data Science Bundle(360+ Courses, 50+ projects)
Python TutorialMachine LearningAWSArtificial Intelligence
TableauR ProgrammingPowerBIDeep Learning
Price
View Courses
360+ Online Courses | 50+ projects | 1500+ Hours | Verifiable Certificates | Lifetime Access
4.7 (86,171 ratings)

Expression Transformation in Informatica 1

Step 2: Navigate to the Data Integration option.

Once the login is successful, the My Services dashboard will appear. This section or the dashboard view is based upon the license subscription options of Informatica.

Select the Data Integration in the My service section to enter into the data integration tool dashboard. The other Tabs such as Administrator, DiscoveryIQ, and Monitor shown in the dashboard are for configuring and managing the data integration resources.

Navigate to the Data Integration option

Step 3: Selecting the New option from the data Integration dashboard.

The Data integration homepage displays the various sections for resource and artifacts creation and the summary of the artifacts.

Selecting the New option from the data Integration dashboard

Step 4: Create a new mapping from the ‘New Asset’ options.

The New Asset window shows multiple options such as creating new Tasks, mappings, Templates, Task Flows, and Components. The New Mapping is the design of the data integration flow using the inbuilt features and functionalities that help in the extract, transform and load (ETL) process.

Create a new mapping from the ‘New Asset’ options

Step 5: Name the Mapping with a meaningful word.

The Mapping windows show the default view with a source and target component views in the design palette. It shows the properties section that allows the user to enter names, select the location and enter the description of the mapping.

We will provide the name of the mapping as ‘DemoMapping’ in the Name text box and click on the ‘save’ button shown on the Top apply the Name to the mapping.

By default, it will show the ‘Invalid’ label on the top of the mapping window. This indicates the source and the destination pallets are not configured with the proper connections. It will be shown as ’valid’ once the connection configuration will be applied.

Name the Mapping with a meaningful word

Step 6: Add the Expression transformation to the mapping.

As Expression Transformation is connected and passive transformation, it needs to be added in between the source and target computer inside the mapping. The Expression option is available on the left section design view and listed as the 4th option with the function f(x) icon.

To add the expression to the mapping select and drag it to the position after the source as shown in the image and save the mapping. Informatica will automatically connect it with the source and target components. Expression properties shown in the bottom section provide the configuration option for General, Incoming Fields, Expression and Advanced properties.

Expression Transformation in Informatica 6

Step 7: In the next step we will write expression transformation to concatenate two strings values representing the first name and last name to an output Field called FullName to show the use of Expression.

Select the Expression option in the properties and click on the + icon to create new by selecting the Field Type as Output Field, entering Name as FullName. Selecting Type as a string and providing the precision as 20 to define the output field size.

Expression Transformation in Informatica 7

Expression Transformation in Informatica 8

Next, we will assign a fixed string value to the value by using the string function available in the Expression option for configuring the output field.

Select the Configure option shown in the Expression section.

Expression Transformation in Informatica 9

Next, to apply the string function in the expression select the ‘built-in function’ option in the second dropdown list of the Field expression window.

Expression Transformation in Informatica 10

Next, select the string option followed by the ‘fx concat’ function from the list. Once the concat function is selected it will appear on the expression editor window. For the example expression, we are entering ‘John’ as string1 and ’Smith’ as string 2 in the Concat function parameter.

The next step is to validate the expression by clicking on the validate button. If there is no syntax issue the green checkbox with ‘The expression’ is valid’ message will appear as shown in the subsequent image. If any issue, you can fix that in the expression editor and validate it again.

Once the expression for the field is valid. Click Ok to return to the Properties View of Expression. The expression can be used with any input ports or fields of available ports for the data manipulation operations.

Expression Transformation in Informatica11

On the Expression properties window, the field level expression will be shown. Save the mapping to apply the expression.

Expression Transformation in Informatica12

We have completed how to perform expressions in Informatica.

The output or variable ports can be used to propagate the transformed data to the subsequent transformation or to the target system in the mapping.

Similarly, there are various ways to use the expression that is implemented based upon the business requirements and according to the target systems.

Conclusion

The expression transformation is very useful to develop the custom business logic and apply it to transform the source data and load it on that target system. Because of the variety of features. This transformation is a mostly used transformation in the Informatica mappings and used for complex data manipulation.

Recommended Articles

This is a guide to Expression Transformation in Informatica. Here we discuss the introduction and how to perform expression transformation in informatica? You may also have a look at the following articles to learn more –

  1. Mapping in Informatica
  2. Router Transformation in Informatica
  3. Transformations in Informatica
  4. Transformations in Informatica with Example
Popular Course in this category
Informatica Training (7 Courses)
  7 Online Courses |  47+ Hours |  Verifiable Certificate of Completion |  Lifetime Access
4.5
Price

View Course

Related Courses

Data Visualization Training (15 Courses, 5+ Projects)4.9
Cloud Computing Training (18 Courses, 5+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Data Science Course

SPSS, Data visualization with Python, Matplotlib Library, Seaborn Package

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more