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
- 6260 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 |
Can you explain tagbatch restructure operator?
How do you load dimension data and fact data? Which is first
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
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)
AGGREGATOR default datatype
specify data stage strength?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del
What is the difference between validate and compile?
What is the difference between orabulk and bcp stages?
what r the stages mostly used in realtime scenarios
What are the different kinds of views available in a datastage director?
Teradata 
