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
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Global and Local shortcuts. Advantages.
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is informatica?
How to Create a folder using pmrep command?
What are the main issues while working with flat files as source and as targets ?
How to start a workflow using pmcmd command?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How to generate sequence numbers without using the sequence generator transformation?
What is different between the data warehouse and data mart?
what are the deliverables?in your project?
What happens when a session fails and you click on recover?
Differentiate between reusable transformation and mapplet.
What is the difference between writing a joiner query in ANSI style and THETA style?
What is update strategy transform?