I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
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
What is the difference between odbc and drs stage?
Describe routines in datastage? Enlist various types of routines.
how many rows sorted in sort stage by default in server jobs
what is the use of surogate key in datastage
What are the features of datastage flow designer?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is size of a transaction and an array means in a datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
how to write server Routine coding?
Can you filter data in hashed file?
Whats difference betweeen operational data stage (ods) and data warehouse?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
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 you explain kafka connector?
If you want to use a same piece of code in different jobs, how will you achieve this?