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 do you understand by term role-playing dimension?
What is a repository manager?
What is the surrogate key?
Explain sessions and how many types of sessions are there?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Explain sessions. Explain how batches are used to combine executions?
What are the static cache and dynamic cache in informatica?
What are Dimensional table?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What will be the approach?
How does the aggregator transformation handle null values?
What are the new features of Power Center 5.0?
What are pre and post-session shell commands?
what is INFORMATICA TESTING process