source file having the data like aabbccc, i want target file
result like a1a2b1b2c1c2c3.
Answer Posted / srinivas
We can do this with below major steps.
i)First split the data into rows each character as one row this can be done by below function in basic trnsformer
Convert(@TM,@FM,Fmt('aabbccddee', "1T"))
ii)Then next step take four stage variables in next transformer apply below logics
stg1----> Outputcolumn of first transfermer.
stg2----> 1
stge3----> if stg4=stg1 then stg3+1 else stg2
stg4----> stg1
stge5----> stg1:stge3
now we will get the below ansr
o/p column
a1
a2
b1
b2
c1
c2
d1
d2
iii)Then convert the rows into one single column.
Thanks
Srini
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the difference between server job and parallel jobs?
Define oconv () and iconv () functions in datastage?
How to RD using transformer?
What is the command line function to import and export the ds jobs?
What are the enhancements made in datastage 7.5 compare with 7.0?
What are the different plug-ins stages used in your projects?
What is merge stage?
What are stage variables and constants?
What is orabulk stage?
What is the purpose of pivot stage?
What is data partitioning?
Triggers,VIEW,Procedures
What are system variables and sequencers in datastage
What is difference between server jobs & parallel jobs?
How to perform incremental load in datastage?