Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / infa dev
Source and the target will the same table from which the
duplicate needs to be deleted from. Then use a lookup trans
on to this same table and then use an update trans with
DD_DELETE if the row is duplicate else do nothing.
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
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
Separate from a database, an information bazaar, and an information stockroom?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the types of presistent cache in look up tr.
How to do unit testing in informatica?
What are the different options available for update strategy?
Different sorts of metadata that stores in the storage facility?
What is session task and command task?
What do you understand by term role-playing dimension?
What is meant by target load plan?
What you know about transaction control transformation?
How can you define user defied event?
Explain informatica architecture - version 8 / 9
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
