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?

Answer Posted / satya

USE WM_CONCAT() FUNCTION

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the databases that informatica can connect to windows?

570


wf dont have integration severances how you can run?

1532


wat are deployement groups in informatica, how it will be used for developers

1244


What is pmcmd command?

664


generate date / time dimension in informatica

711






Can anyone tell me the new features in Informatica 9 Version?

1522


What are the different lookup cache(s)?

612


Differentiate between Load Manager and DTM?

1655


State the differences between sql override and lookup override?

611


What is dynamic cache?

602


Separate from an archive server and a powerhouse?

485


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1613


Sequence generator, when you move from develoment to production how will you reset

1395


What are the main features of Oracle 8i with context to datawarehouse?

1670


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1844