hw cn v elimate dublicate values from lookup without
overriding sql?
Answers were Sorted based on User's Feedback
Answer / preeti
hi,if I understand this question correctly,lookup itself
eliminate duplicate rows by having options like First
Value,Last Value.So whenever there are more than one row
for matching lookup condition then it gets eliminated by
first value.last Value option.Let me know if I am wrong
Is This Answer Correct ? | 33 Yes | 2 No |
Answer / bsgsr
hi, preeti,
u r absolutely correct.
the main functionality is to avoid duplicate rows by
selecting first or last value only when the record kming
from the source has multiple matches with the look up cache.
mail meif u r interested in kt
9866188658 bsgsr12@gmail.com
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vijay
using dynamic lookup in lookup t/r we can easily eliminate
duplicates.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / honey
We can remove the duplicate values from the lookup by using
the DISTINCT clause with SQL queries.
Is This Answer Correct ? | 2 Yes | 6 No |
Answer / chandra
in the source qualifier select the prequalifier and select
the distinct clause
Is This Answer Correct ? | 0 Yes | 6 No |
Answer / reddy
hi,
we can eliminate duplicate values by camparision primary key
using lookup
Is This Answer Correct ? | 1 Yes | 7 No |
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is workflow variable? When we use workflow variable? Can any one explain me with one example???
What is the difference between a router and a filter transformation?
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
Which transformation should we use to normalize the COBOL and relational sources?
4 Answers DELL, IBM, Lehman Brothers,
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What exactly mentioned in High level design document.can somebody explain me sequentialy.
What is depict expression change?
How to improve the performance of a session using sorter transformation?
How can we remove the duplicates from flat file source?
suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?