Interested to Buy Any Domain ? << Click Here >> for more details...
if i have records like these
(source table)
rowid name
10001 gdgfj
10002 dkdfh
10003 fjfgdhgjk
10001 gfhgdgh
10002 hjkdghkfh
the target table should be like these by using expression
tranformation.
(Target table)
rowid name
10001 gdgfj
10002 dkdfh
10003 fjfgdhgjk
xx001 gfhgdgh
xx002 hjkdghkfh
(that means duplicated records should contain XX in there
rowid)
- 5 Answers
- 13089 Views
- iFlex, I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How can you differentiate between powercenter and power map?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Write the unconnected lookup syntax?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How to join three sources using joiner?
What is the meaning of up gradation of repository?
Make a note of the quantity vaults made in informatica?
What is a repository? And how to add it in an informatica client?
Explain the code page compatibility?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is meant by lookup transformation? Explain the types of lookup transformation?
Explain pushdown optimization $pushdownconfig parameter - informatica
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Why update strategy and union transformations are active?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
