I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
- 2 Answers
- 5283 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to read multiple files using a single datastage job if files have the same metadata?
How complex jobs are implemented in datstage to improve performance?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What is the difference between operational data stage (ods) and data warehouse?
Have you have ever worked in unix environment and why it is useful in datastage?
What are the some differences between 7.x and 8.x version of datastage?
What are the different options associated with dsjob command?
How to reverse the string using SQL?
what is use of SDR function?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Why fact table is in normal form?
What is the difference between in process and inter process?
What are the steps required to kill the job in Datastage?
What is difference between server jobs & parallel jobs?
What is the difference between informatica and datastage?
