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)
Answers were Sorted based on User's Feedback
Answer / 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|
Answer / 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
|Is This Answer Correct ?||4 Yes||3 No|
Answer / dave
May be i understood question wrong , but :
For unique records you can use in Source Qualifier SQL with
having count condition = 1 to cut the unique records to one
And for second target same query but with >1 condition
|Is This Answer Correct ?||2 Yes||9 No|
How to join three sources using joiner?
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
how DTM buffer size and buffer block size are related
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is the difference between normal and bulk loading? Which one is recommended?
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
what is hash table in informatica?
What is the difference b/w natural key and surrogate key
What are the different types of schemas?
sample mappings for scd1,scd2 and scd3
difference between stop and abort