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)
Answer Posted / harish konda
We know that Dynamic Look Up Cache returns 1 for insert and
2 for update. So connect the source to the lookup which is
Dynamic and in next in router create 2 conditions. Records
which new it will return 1 and records which are there it
returns 2.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain Dataware house architecture .how data flow from intial to end?
wf dont have integration severances how you can run?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are the various types of transformation?
How do you load first and last records into target table?
what is the size of your data warehousing?
What is informatica?
How can we improve session performance in aggregator transformation?
How do we call shell scripts from informatica?
What is the scenario which compels informatica server to reject files?
What is the difference between informatics 7x and 8x and what is latest version?
Is there any way to read the ms excel datas directly into informatica?
Which version configuration tool used in ur project?
Explain constraint based loading in informatica