Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12363 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
What do you mean by blocking transformation?
Explain pmcmd command usage in informatica
What is powercenter on grid?
What is incremental aggregation?
can we override a native sql query within informatica? How do we do it?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are the differences between joiner transformation and source qualifier transformation?
What is sq transformation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How to extract sap data using informatica? What is abap? What are idocs?
What are the different types of olap? Give an example?
How do you load first and last records into target table?
tell me 5 session failure in real time how can you solve that in your project?
What will be the approach?
What is resilience time?
