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
Design time, run time. If you don't create parameter what will happen
what is $$$$?
Difference between Target-based loading and constraint-based loading?
Mention a few design and development best practices for informatica?
I have a flat file, want to reverse the contents of the flat file
What is a connected transformation?
Sequence generator, when you move from develoment to production how will you reset
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
generate date / time dimension in informatica
What are the tuning techniques you applied during your last project
Is it possible to use a client with different version than that of its Informatica server?
difference between repository database and repository service?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Quickly characterize reusable change?