How to merge First Name & Last Name?

Answer Posted / jvdwhinfo

Hi guys,

Here all the above answers are absolutely correct.
i.e we can use both concatenate operators as well as pipe
operators.We gonna get the desired output.
But only difference is the performance.We'll get better
performance by using pipe (||) operator rather than
concatenate.

Please let me know if you want to give further suggestions.
Thanks.
James

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differences between version 7.x and 8.x.

1522


According to his methodology what all you need before you build a datawarehouse

1290


Do you find any difficulty while working with flat files as source and target?

769


Explain the features of connected and unconnected lookup.

639


What do you mean by blocking transformation?

675






I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

901


What is dimensional table?

707


What are the measure objects?

770


Explain informatica architecture - version 8 / 9

759


Can you generate sequence numbers without using the sequence generator transformation?

672


what is unit testing?tell me proceedure

1880


What is the maplet?

697


What is meant by LDAP users?

776


Separate from a database, an information bazaar, and an information stockroom?

702


How to call shell scripts from informatica?

662