first use concatenate operator '',then use union

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?

Question Posted / shaik mahamad rafi

Answer Posted / shaik mahamad rafi

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

which one is better performance wise joiner or look up

1025

How to implement security measures using repository manager?

1076

What is flashback table ? Advance thanks

1869

How to convert multiple rows to single row (multiple columns) in informatica

1314

How can we store previous session logs?

988

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1804

what is index?how it can work in informatica

1978

Global and Local shortcuts. Advantages.

1952

What is an expression transformation in informatica?

958

What are the components of Informatica? And what is the purpose of each?

980

design of staging area?

1957

What is the meaning of decode in informatica?

1068

Explain the informatica workflow?

996

What is Data Caches size?

1029

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4034