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 data aggregation?

1148

---

What is staging variable?

1153

---

How you Implemented SCD Type 1 & Type 2 in your project?

4179

---

Name the different types of Lookups in Datastage?

1313

---

What is a ds designer?

1114

---

Define Job control?

1226

---

What are the differences between datastage and informatica?

1229

---

What is merge stage?

1382

---

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?

2281

---

Define orabulk and bcp stages?

1178

---

Can we use target hash file as a lookup ?

3372

---

What is datastage engine?

1225

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1430

---

Explain ibm infosphere information server and highlight its main features?

1140

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

3019

---