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
What are the advantages of informatica?
What does refresh system mean, and what are its distinctive choice?
What is dynamic cache?
Target increases every day even though no new record was inserted
What is workflow? What are the components of workflow manager?
What are the restrictions of union transformation?
What happens when a session fails and you click on recover?
have u done any performance tuning? how u ll do?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
write a query to retrieve the latest records from the table sorted by version(scd)
lookup transformation with screenshots
What are the designer tools for creating transformations?
What do you understand by a term domain?
Explain the tuning lookup transformation - informatica
What is informatica metadata and where is it stored?