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
What is flashback table ? Advance thanks
What are the prerequisite tasks to achieve the session partition?
How to elaborate powercenter integration service?
What is meant by active and passive transformation?
Explain the aggregator transformation?
Differentiate between joiner and lookup transformation?
What is decode in static cache?
How can one identify whether mapping is correct or not without connecting session?
What are the types of presistent cache in look up tr.
What is meant by a domain?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What do you understand by SOA of Informatica?
Could you explain what is enterprise data warehouse?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?