Concatenation of two fields

Expression Transformation

Expression transformation is used to perform any Non-aggregate calculations, conditional statements for single row. For example you might need to adjust the employee salaries, concatenate first and last names, convert string to numbers.

In this example we are Concatinating FIRST_NAME and LAST_NAME

1. Import the Source and target Definitions

2. Create a Mapping

3. Drag the Source Definition the mapping designer workspace.

4. Create an Expression transformation. Add one output port as follows and clear the output(O) for the first_name and last_name ports because we are going to use these ports as input only.

img-page0001 (1)

O_NAME= LAST_NAME|| ‘,’||FIRST_NAME

5.Drag and drop the target definition to workspace

6.Link the columns from expression to Target Definition as per data mapping sheet
img-page0001

15 Comments to “Concatenation of two fields

  1. I wanted to develop a brief comment to appreciate you for all the precious steps you are writing here. My extended internet research has at the end been compensated with really good knowledge to write about with my companions. I would believe that we readers are quite blessed to dwell in a very good website with many brilliant people with helpful opinions. I feel rather grateful to have encountered your webpages and look forward to some more exciting minutes reading here. Thank you once again for all the details.
    calvin klein outlet store http://www.coremosa.es/rem.asp?so=calvin-klein-outlet-store

  2. Hiya, I’m really glad I’ve found this information. Nowadays bloggers publish only about gossips and internet and this is really irritating. A good web site with interesting content, that’s what I need. Thank you for keeping this website, I will be visiting it. Do you do newsletters? Can not find it.

  3. I do not even know how I ended up here, but I thought this post was good. I don’t know who you are but definitely you’re going to a famous blogger if you aren’t already 😉 Cheers!

  4. Hello my loved one! I want to say that this post is awesome, great written and come with approximately all significant infos. Iˇd like to look extra posts like this .

  5. I think other site proprietors should take this website as an model, very clean and magnificent user friendly style and design, as well as the content. You are an expert in this topic!

  6. Hi to every one, for the reason that I am in fact keen of reading this blog抯 post to be updated daily. It includes good information.

  7. Itˇs in reality a nice and helpful piece of info. Iˇm glad that you simply shared this useful information with us. Please keep us informed like this. Thank you for sharing.

  8. Whats up very nice web site!! Guy .. Excellent .. Amazing .. I will bookmark your site and take the feeds alsoI am happy to seek out a lot of useful information right here within the post, we need develop more strategies on this regard, thanks for sharing. . . . . .
    nike air max baratas milanuncios [url=http://www.novoconceitoplanejados.com.br/jadb.php?es=nike-air-max-baratas-milanuncios]nike air max baratas milanuncios[/url]

  9. Good blog! I really love how it is easy on my eyes and the data are well written. I am wondering how I might be notified when a new post has been made. I’ve subscribed to your RSS which must do the trick! Have a nice day!

  10. Very nice article and straight to the point. I am not sure if this is actually the best place to ask but do you people have any ideea where to hire some professional writers? Thanks :)
    tiendas ropa interior masculina [url=http://www.milcosas.es/lcos.asp?so=tiendas-ropa-interior-masculina]tiendas ropa interior masculina[/url]

  11. Excellent site. A lot of useful info here. Iˇm sending it to a few pals ans additionally sharing in delicious. And naturally, thanks in your sweat!

  12. I’ve been absent for a while, but now I remember why I used to love this site. Thanks , Iˇll try and check back more often. How frequently you update your site?
    timberland krak贸w [url=http://poszukujemy.com.pl/pie/sklep-timberland.html]timberland krak贸w[/url]

  13. Hi, i think that i saw you visited my site so i came to eturn the favor?I’m attempting to find things to enhance my site!I suppose its ok to use some of your ideas!!

  14. I have been surfing online more than three hours today, yet I never found any interesting article like yours. It抯 pretty worth enough for me. In my opinion, if all web owners and bloggers made good content as you did, the net will be much more useful than ever before.

    1. heyy thanks for ur feedback..

Leave a Reply

Your email address will not be published. Required fields are marked *