Interested to Buy Any Domain ? << Click Here >> for more details...
How to merge First Name & Last Name?
- 8 Answers
- 19002 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 is the architecture of any Data warehousing project?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is Performance tuning in Informatica?
Could any one to tell Fact table Partitioning?
what is data driven in informatica
star and snowflake schema?
in realtime which situations u can use unconnected lookup transformation
What does role playing dimension mean?
how to create user defined function (udf) in informatica
how to calculate the optimum cache size in aggregator transformation?
How do you load first and last records into target table?
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
Teradata 
