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
sed,awk,head
What is the process of killing a job in datastage?
What are the types of jobs we have in datastage?
On which interface you will be working as a developer?
What is oci?
What is the flow of loading data into fact & dimensional tables?
Why we use surrogate key?
What is the sortmerge collector?
how to sort two columns in single job in datastage.
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What are the partitioning techniques available in link partitioner?
What are the different type of jobs in datastage?
How rejected rows are managed in datastage?
What is usage analysis in datastage?
What all are the different way to run a job?