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
- 6356 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 many types of stage?
What are the types of hashed files in data stage
What is the project in datastage?
What is the flow of loading data into fact & dimensional tables?
What are the difference types of stages?
Describe the main features of datastage?
How do you remove duplicate values in datastage?
What is datastage?
What is oci?
What are the different layers in the information server architecture?
What are system variables and sequencers in datastage
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What is orabulk stage?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
