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

What are the functionalities of link partitioner?

0 Answers  

How do you start developing a datastage project?

0 Answers  

what is the difference between the join and look up explin me one exmple

3 Answers  

How to remove blank spaces from data?

3 Answers  

How many areas for files does datastage have?

0 Answers  

What is exact difference between Parallel Jobs and server Jobs..

8 Answers   DELL, IBM,

I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:--&#61664; capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3

2 Answers   TCS,

how to call sequential generator in datastage?

1 Answers   IBM,

What are the difference types of stages?

0 Answers  

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers   Infosys,

i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?

4 Answers  

what is materialized view used datastage?

1 Answers   HSBC,

For more Data Stage Interview Questions Click Here
Categories