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
- 12599 Views
- iFlex, I also Faced
- E-Mail Answers
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 do you load only null records into target?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is joiner transformation?
Is there any target staging area in informatica not staging area
What are the new features of informatica 9.x developer?
design of staging area?
define galaxy repository in informatica
Explain the shared cache and re-cache?
Mention few advantages of router transformation over filter transformation.
During the running session, output files are created by informatica server. Enlist few of them.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is the difference between STOP and ABORT options in Workflow Monitor?
Explain what transformation and how many are there in informatica?
server hot-ws270 is connect to Repository B. What does it mean?
