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?
- 2 Answers
- 6199 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Can you define merge?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Name the different sorting methods in datastage.
What is aggtorec restructure operator?
Differentiate between odbc and drs stage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Which algorithm you used for your hashfile?
What are orabulk and bcp stages?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What are the differences between datastage and informatica?
What are the functionalities of link collector?
What is meta stage?
Is it possible to query a hash file?
