Interested to Buy Any Domain ? << Click Here >> for more details...
How to merge First Name & Last Name?
- 8 Answers
- 19073 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 |
how to get the only updated records in the target
What is a command that used to run a batch?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How do you take care of security using a repository manager
What is sequence generator transformation in informatica?
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
differences between service based and product based?
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
Teradata 
