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


I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

Answers were Sorted based on User's Feedback



I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in dat..

Answer / anchalthakran

Source file Input: abcdefghijklmnopqrs

Solution:- seq file---> transformer stage---> seq file

under function-->string-->convert function will give desired output.

Convert("j" , "z" , "abcdefghijklmnopqrs" )

Target file Output: abcdefghizklmnopqrs

Is This Answer Correct ?    6 Yes 2 No

I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in dat..

Answer / trupti

InputField = "abcdefghijklmnopqrs"

step by step we can use transformer functions as,

1. left(InputField,10) ==> OP will be 'abcdefghij'

2. Use above output in
right (abcdefghij,1)= 'J'

The final derivation will be like below,

Convert(right(left(InputField,10),1),'Z',Inputfield)

Output :- abcdefghiZklmnopqrs

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Data Stage Interview Questions

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?

1 Answers   IBM,


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

0 Answers  


which r the connectors used in san?

0 Answers  


whats relation between configuration file and datasets?

2 Answers   L&T, Wipro,


How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.

5 Answers  


What are data elements?

0 Answers  


can any one tell me how to install datastage 8.1 in windows xp with wizard

2 Answers  


Explain the ChangeApply stage?

11 Answers  


What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

2 Answers  


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

0 Answers   UHG,


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

2 Answers   Infosys,


How can we achive parallelism

1 Answers   CTS,


Categories