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)
Answer Posted / 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 |
Post New Answer View All Answers
How to partition the Session?
How to create Target definition for flat files?
What do you mean by blocking transformation?
Different qualification between a related rotate toward the sky and isolates look upward?
What does “tail –f” command do and what is its use as an Informatica admin.
Explain incremental aggregation in informatica
Reusable transformation and shortcut differences
How to update source definition?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How can you generate reports in informatica?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Explain constraint based loading in informatica
How identifying bottlenecks in various components of informatica and resolving them?
Which are the different editions of informatica powercenter that are available?
How to load the data from a flat file into the target where the source flat file name changes daily?