Answer Posted / krishnakanth.ch

First make sure the values are sorted by rowid and passed
to an expression transformaion.Now create a variable port
in the exp. Lets think var1 and make it empty in the
expression .

now compare rowid with var1 by

IIF(VAR1=ROWID,XX||SUBSTR(ROWID,3,3),ROWID)

When the session starts, since initially the var1 is null,
it will be replaced with first rowid. When the second
record is passed, the values will match the required format
of rowid will be passed and remember to pass the value in
the var1 to the next transformation or target.

Hope this will solve.
Please let me if anything is wrong or does not work out.

What could be the possible resons of locks by user?

1146

---

How do you use reject loader.

2651

---

How to differentiate between the active and passive transformations?

1231

---

In informatics server which files are created during the session rums?

1171

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5881

---

What are the main features of Oracle 8i with context to datawarehouse?

2164

---

What all are steps in up gradation of Informatica server?

1096

---

What are the databases that informatica can connect to windows?

1103

---

How to partition the Session?

1154

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2089

---

What is informatica etl tool?

1061

---

What do you understand by term role-playing dimension?

1121

---

Enlist few areas or real-time situations where informatica is required.

1144

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2186

---

wf dont have integration severances how you can run?

1989

---