Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

Suppose take my name "Reddyvaraprasad"

From source it is coming Reddy vara prasad

Need to get As Reddyvara prasad/

Question Posted / prasad

Answers were Sorted based on User's Feedback



Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad ..

Answer / akila

Create 3 stage variables to split the name into three and
then concatenate

SV1 = Field(NAME," ",1)
SV2 = Field(NAME," ",2)
SV3 = Field(NAME," ",3)

Then concatenate in the column derivation as sv1:sv2:" ":sv3

Is This Answer Correct ?    8 Yes 1 No

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad ..

Answer / hussy

I am sowwie akila. tat was the correct answer mistakenly I
have clicked on the other option. hope u dont mind

Is This Answer Correct ?    0 Yes 0 No

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad ..

Answer / 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

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad ..

Answer / ambi

select Replace('Reddyvaraprasad','vara','vara ')

Is This Answer Correct ?    5 Yes 6 No

Post New Answer

More Data Stage Interview Questions

Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.

2 Answers   IBM,

Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x

7 Answers  

how can we create rank using datastage?what is the meaning of rank?

0 Answers   IBM,

what is the use of invokation id

2 Answers   IBM,

one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?

8 Answers   IBM,

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

0 Answers   TCS,

What are the differences between datastage and informatica?

0 Answers  

What is the Difference Between DataStage 7.5 version and 8.1 Version?

10 Answers   IBM,

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

0 Answers  

what is data mapping

2 Answers  

Please tell me What is difference between 8.0 and 8.1

1 Answers   IBM,

What are the partition techniques available in your last project?

1 Answers  

For more Data Stage Interview Questions Click Here
Categories