I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
Answers were Sorted based on User's Feedback
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 |
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 |
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?
Different ways a project can be moved to production ?...example ….export-import and Version control.
which r the connectors used in san?
whats relation between configuration file and datasets?
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.
What are data elements?
can any one tell me how to install datastage 8.1 in windows xp with wizard
Explain the ChangeApply stage?
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
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...
CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?
How can we achive parallelism