Suppose take my name "Reddyvaraprasad"

From source it is coming Reddy vara prasad

Need to get As Reddyvara prasad/

Answer Posted / vaibhav

Hi Akila,

What if input name comes as Ajay Rathore... Surname should be differentiated with space and middle name should be concatenated with first name...then this solution might be wrong...

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

root tree will find which is server job and which is parallel job?

1455


AGGREGATOR default datatype

937


Explain Quality stage?

671


What is the purpose of pivot stage?

608


What are orabulk and bcp stages?

649






Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2746


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

2993


if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1758


Describe the main features of datastage?

660


If you want to use a same piece of code in different jobs, how will you achieve this?

796


Name the command line functions to import and export the DS jobs?

709


On which Dimension Table you implemented SCD Type in your Project

1582


how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

364


table actions available in oracle connector?

1096


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3271