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 / shaik mahamad rafi

first use concatenate operator '',then use union

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create the source and target database connections in server manager?

857


What is incremental aggregation?

849


How can we store previous session logs?

814


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2158


Explain lookup transformation source types in informatica

916


Explain why we use partitioning the session in informatica?

831


Explain incremental aggregation in informatica

893


What is confirmed fact in dataware housing?

6283


What differs when we choose the sorted input for aggregator transformation?

823


What is dimensional table?

838


In warehouses how many schemas are there?

825


How union transformation is used?

810


Explain what are the different types of transformation available in informatica.

803


Write the program through which the records can be updated?

783


without table how to come first record only in oracle?

2064