Interested to Buy Any Domain ? << Click Here >> for more details...
How to merge First Name & Last Name?
- 8 Answers
- 19334 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 |
i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?
Explain what are the different types of transformation available in informatica.
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
Explain pushdown optimization and types in informatica
What are the two modes of datamovement in informatica sever?
what is degenerated dimension?
What is the difference between SOURCE and TARGET BASED COMMITS?
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
Explain incremental aggregation in informatica
Enlist the tasks for which source qualifier transformation is used.
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
i have two source data there is no pk,fk how to join the two sources
Teradata 
