Interested to Buy Any Domain ? << Click Here >> for more details...
source file having the data like aabbccc, i want target file
result like a1a2b1b2c1c2c3.
- 2 Answers
- 7441 Views
- I also Faced
- E-Mail Answers
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?
What are the areas of application?
Highlight the main features of datastage?
What are routines in datastage? Enlist various types of routines.
Explain ibm infosphere information server and highlight its main features?
Differentiate between odbc and drs stage?
Define Job control?
AGGREGATOR default datatype
What could be a data source system?
What is the different type of jobs in datastage?
in oracle target stage when we use load option and when we use upsert option?
Give an idea of system variables.
What is the difference between datastage and informatica?
What are stage variables?
Differentiate between operational datastage (ods) and data warehouse?
