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.

Where can we find the throughput option in informatica?

999

---

How does a rank transform differ from aggregator transform functions max and min?

1147

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1994

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

966

---

What does role playing dimension mean?

999

---

can we override a native sql query within informatica? How do we do it?

1055

---

What are the components of workflow manager?

1019

---

How can one identify whether mapping is correct or not without connecting session?

1371

---

Explain joiner transformation in informatica

1077

---

What is flashback table ? Advance thanks

1873

---

Explain the use of aggregator cache file?

1192

---

What is an Integration service in Informatica?

1085

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1014

---

How to partition the Session?

1045

---

Have you worked with/created Parameter file

1615

---