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 / rao

its not working

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are batches?

619


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1529


How can a transformation be made reusable?

664


What is rank transform?

601


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

808






What are session parameters ? How do you set them?

1376


Have you worked with/created Parameter file

1226


What are the different clients of powercenter?

599


In informatics server which files are created during the session rums?

635


State the limitations where we cannot use joiner in the mapping pipeline?

547


What is workflow monitor?

595


What is domain in terms of informatica?

561


What is union transformation in informatica?

701


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3510


How can we use mapping variables in informatica?

597