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 are the basic requirements to join two sources in a source qualifier transformation using default join?
Can we create a Integration service without a Repository service and vice versa?
What are the data movement modes in informatica?
Explain in detail about scd type 1 through mapping.
What do you understand by SOA of Informatica?
Under what condition selecting sorted input in aggregator may fail the session?
State the differences between sql override and lookup override?
What is the meaning of decode in informatica?
What is dimensional table?
What are the different types of transformation available in informatica.
What do think which one is the better joiner or look up?
Tell me about Propagate functions in informatica
What is a sequence generator transformation?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How does a rank transform differ from aggregator transform functions max and min?