how to send unique records to one target and duplicate
records to another target by using dynamic lookup cache?????
please explain me briefly///(when we use this we look up on
which target unique target ya duplicate target)
- 3 Answers
- 11306 Views
- Cognizant, HP, TCS, I also Faced
- E-Mail Answers
Answer Posted / sarvesh
whenever we create dynamic lookup a default col gets added i.e. newlokuprow it has a defaul value 1 for insert that is newrow and 0 for delete or duplicate or same row which already exists. so just use router tr and separate the 0 value row will eliminate the duplicates.
| Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
How can we use mapping variables in informatica? Where do we use them?
Explain the use of aggregator cache file?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the way to execute pl/sql script using informatica mapping?
Where can we find the throughput option in informatica?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
On which transformations you created partitions in your project?
What are different types of transformations available in informatica?
What is informatica worklet?
What are active transformations.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Explain how to import oracle sequence into informatica?
Informatica Checkpoints
If informatica has its scheduler why using third party scheduler?
