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 / 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 |
Post New Answer View All Answers
Performance tuning in UNIX for informatica mappings?
Can you use flat files in Mapplets.
What is main use of mapplet?
what is the size of your data warehousing?
Implementation methodology
what are 3 tech challenges/ common issues you face?
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
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Why is sorter an active transformation?
What is an Integration service in Informatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is Session and Batches?
What is the maplet?
What are the main issues while working with flat files as source and as targets ?