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
- 12678 Views
- iFlex, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jyothiram
PUT SORTER WITH KEY OF ROWID IN FIRST EXPRESSION FLAG THE
RECORDS WHICH IS HAVING MORE THAN ONCE ,TAKE PRV PORT AS
VARIABLE MATCH IT WITH CURRENT AND SET FLAG OUT ACCORDINGLY,
IN NEXT EXPRESSION CHCEK FOR FLAG, IF IT SETS
DO 'XX'||SUBSTR(ROWID,3) OTHER WISE ROWID ONLY . HOPE THIS
WILL SOVE .
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / rajendra
Through Dynamic lookup you can handle it very easily.
| Is This Answer Correct ? | 3 Yes | 1 No |
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 |
Answer / mfg
create an output port and write the expression to replace
values or create a stored procedure and call it expression
transformation
| Is This Answer Correct ? | 1 Yes | 2 No |
what is materialized view?
what is the drillup & drill down?and use of the drill up and drill down?
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
How to create Target definition for flat files?
what is the location of parameter file in informatica?
Is there any target staging area in informatica not staging area
Explain load alternative records / rows into multiple targets - informatica
what is metadata?
What is the different lookup cache(s)?
I need an oracle query for convert Char to Integer?. Can any one help me how to do this?
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
what is mystery dimension?
Teradata 
