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
What is rank transformation?
Explain the difference between mapping parameter and mapping variable?
What are the components of Informatica? And what is the purpose of each?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
When do you use sql override in a lookup transformation?
What is native users?
What is meant by pre and post session shell command?
How to differentiate between the active and passive transformations?
How does a sorter cache works?
Differentiate between Load Manager and DTM?
what is index?how it can work in informatica
pmscmd startworkflow -sv
How many numbers of sessions can one group in batches?
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?
What do you mean by enterprise data warehousing?