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 is parallel processing in informatica?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Explain target update override in informatica
What is the format of informatica objects in a repository?
What is session task and command task?
What is a joiner transformation and why it is an active one?
What is a repository manager?
What is the difference between source qualifier transformations source filter to filter transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the components of the workflow manager?
Explain transaction control transformation in informatica
Separate from a database, an information bazaar, and an information stockroom?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is the use of target designer?
What is event and what are the tasks related to it?