I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
- 2 Answers
- 5267 Views
- I also Faced
- E-Mail Answers
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 |
Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)
What are the partitioning techniques available in link partitioner?
Explain how a source file is populated?
what is the function in Transformer stage can act as Rank function in Oracle
What is exact difference between Parallel Jobs and server Jobs..
Name the third party tools that can be used in datastage?
Explain connectivity between datastage with datasources?
How you Implemented SCD Type 1 & Type 2 in your project?
What is the method of removing duplicates, without the remove duplicate stage?
what is materialized view used datastage?
How can we run same job in 1 day 2 times
If you want to use a same piece of code in different jobs, how will you achieve this?
Teradata 
