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
- 12811 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
Why filter transformation is an active one?
Mention few advantages of router transformation over filter transformation.
What is transformation?
How big was your fact table
What is a grid in Informatica?
What are the mapping parameters and mapping variables?
Explain the scenario which compels informatica server to reject files?
What is the difference between writing a joiner query in ANSI style and THETA style?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
what are the Methods For Creating Reusable Transformations?
wf dont have integration severances how you can run?
what is the size of u r source(like file or table)?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How do you take back up of repository?
To import the flat file definition into the designer where should the flat file be placed?
