How to merge First Name & Last Name?
- 8 Answers
- 19773 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / saradhi
by using concatination operator u can get it.
firstname||lastname
| Is This Answer Correct ? | 15 Yes | 1 No |
Answer / giri
Very Simple Use Expression transformation add condition Concat(firstname+lastname)
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / ramesh.b
Use Expression transformation write condition Concat(firstname,lastname)
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / abinitiofreak
we have to use firstname||lastname expression
| Is This Answer Correct ? | 2 Yes | 1 No |
let the source is like this
first name last name
venkatesh malneni
rajesh tumalla
siva kalle
use an expression t/r create an output port with condition first name||last name
CONNECT THE OUTPUT TO THE TARGET
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / tejeya
Find the space by using the Instr() function and then split
into two.. then merge.
| Is This Answer Correct ? | 2 Yes | 6 No |
What are the prerequisite tasks to achieve the session partition?
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
How to elaborate tracing level?
any body can say about all versions of informatica ?how many versions ?
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
How is Data Models Used in Practice?
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
How can we delete duplicate rows from flat files?
what is work of PUSH DOWN option
Describe two levels in which update strategy transformation sets?
Teradata 
