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
What are batches?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How can a transformation be made reusable?
What is rank transform?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What are session parameters ? How do you set them?
Have you worked with/created Parameter file
What are the different clients of powercenter?
In informatics server which files are created during the session rums?
State the limitations where we cannot use joiner in the mapping pipeline?
What is workflow monitor?
What is domain in terms of informatica?
What is union transformation in informatica?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How can we use mapping variables in informatica?