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 / rajendra
Through Dynamic lookup you can handle it very easily.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Mention some types of transformation?
What is main use of mapplet?
What is informatica metadata and where is it stored?
What is Session and Batches?
How union transformation is used?
Write the prerequisite tasks to achieve the session partition?
what is the hint? how to use it to reduce the query processing in program?
What do mean by local and global repository?
Explain pmcmd command usage in informatica
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
tell me the rules and responsblites in our project(my project is development)
explain about unit testing? in real time?
What is Cognos script editor?
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
What does “tail –f” command do and what is its use as an Informatica admin.