How to merge First Name & Last Name?

Answer Posted / tejeya

Find the space by using the Instr() function and then split
into two.. then merge.

Is This Answer Correct ?    2 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is union transformation?

741


What is a grid in Informatica?

823


What are the types of caches in lookup? Explain them.

746


What is meant by target load plan?

734


What are some examples of informatica etl programs?

729


What is depict expression change?

802


How to generate or load values in to the target table based on a column value using informatica etl tool.

825


what is the complex transformation you used in informatica

2379


How to do unit testing in informatica?

936


What is meant by incremental aggregation?

756


Define enterprise data warehousing?

860


How can a transformation be made reusable?

845


What is the difference between informatics 7x and 8x and what is latest version?

788


In which transformation you cannot drag ports into it?

1038


Describe the impact of several join conditions and join order in a joiner transformation?

822