Interested to Buy Any Domain ? << Click Here >> for more details...
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)
- 5 Answers
- 12590 Views
- iFlex, I also Faced
- E-Mail Answers
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
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Briefly define a session task?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is the status code in stored procedure transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How many ways are there to create ports?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are the types of presistent cache in look up tr.
Informatica Checkpoints
How might one distinguish in the case of mapping is right or not without associating session?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is a predefined event?
Describe expression transformation?
What is sequence generator transformation in informatica?
