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

Define meta stage?

1200

---

How many areas for files does datastage have?

1152

---

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?

2228

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

779

---

What is the difference between datastage and informatica?

1118

---

how to implement scd2 in datastage 7.5 with lookup stage

5605

---

Name the different types of Lookups in Datastage?

1256

---

Name the different sorting methods in datastage.

1049

---

What is the process of killing a job in datastage?

1018

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2812

---

How do you start developing a datastage project?

1103

---

If you want to use the same piece of code in different jobs, how will you achieve it?

1152

---

What is the purpose of pivot stage and types of containers in datastage

1037

---

What are the different common services in datastage?

1284

---

How we can covert server job to a parallel job?

1145

---