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...


Suppose take my name "Reddyvaraprasad"

From source it is coming Reddy vara prasad

Need to get As Reddyvara 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, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers   Cap Gemini, IBM,


1)How to Duplicate Records Delete in Sequential file?

4 Answers   IBM, TCS,


what is materialized view used datastage?

1 Answers   HSBC,


1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

0 Answers  


What are datastage sequences?

0 Answers  


i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

3 Answers   Cap Gemini,


what is the diff between sequential file and fileset stages?

3 Answers  


what is the use of invokation id

2 Answers   IBM,


Different ways a project can be moved to production ?...example ….export-import and Version control.

0 Answers  


how to call sequential generator in datastage?

1 Answers   IBM,


How can we select pr retrieve the particular row in dataset by using orchadmin command?

1 Answers   IBM,


What is the use of hoursfromtime() function in transformer stage in datastage?

0 Answers  


Categories