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
- 13040 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
What is sq transformation?
what is $$$$?
What is informatica?
What is a repository? And how to add it in an informatica client?
How do you load alternate records into different tables through mapping flow?
what is the size of your data warehousing?
what is degenerated dimension?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Differences between version 7.x and 8.x.
Differentiate between sessions and batches?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is event and what are the tasks related to it?
How to elaborate tracing level?
EXL informatica Questions
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
