Interested to Buy Any Domain ? << Click Here >> for more details...
How to extract original records at one target & Duplicate
records at one target? {with out using EXPRESION
transformation and sequence generator transformation?}<-this
is important
- 4 Answers
- 10320 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / usha
by using dynamic lkp its possible...
in dynamic lkp if we r having 2 records..
i will inser 1st record and will update second record...
when ever data inserted in to the target cache get
refreshed..
we ttake dynamic lkp..
by defaul..new lkp row port is added...
we should enable the associatve port...
here we should give the condition ..
in router we should give condition as newlkp=1--it will
insert...
if newlkp=0 means duplicate recorts
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the use of source qualifier?
explain abt ur project architecture?
What is the advantage of informatica?
Informatica settings are available in which file?
What is the Process to creating lookup transformation in informatica
What is repository manager?
What are pre and post-session shell commands?
What are mapplets?
How would you join a node to the already existing domain?
What is the fact table?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Difference between Target-based loading and constraint-based loading?
what is the hint? how to use it to reduce the query processing in program?
Is stop and abort are same in informatica?
What is native users?
