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
- 10709 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 |
why do u use shortcuts in informatica.?
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
What are the designer tools for creating tranformations?
How to delete duplicate row using informatica?
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
How might one distinguish in the case of mapping is right or not without associating session?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
i have 2 session s1 execute s2 load first session fail what is the reason?
What are the uses of a Parameter file?
What are the different threads in DTM process?
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
Briefly define reusable transformation?
Teradata 
