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
- 12470 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 are the new features of informatica 9.x in developer level?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is status code in informatica?
what is degenerated dimension?
How do you load unique records into one target table and duplicate records into a different target table?
How do you load alternate records into different tables through mapping flow?
what is index?how it can work in informatica
What is a stored procedure transformation?
What if the source is a flat-file?
While migrating the data from one environment to another environment how would you manage the connections?
What is the cumulative sum and moving sum?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How you prepared reports for OLAP?
What is the difference between a repository server and a powerhouse?
What is joiner transformation?
