hw cn v elimate dublicate values from lookup without
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
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
|Is This Answer Correct ?||1 Yes||0 No|
Answer / vijay
using dynamic lookup in lookup t/r we can easily eliminate
|Is This Answer Correct ?||2 Yes||1 No|
Answer / surender
|Is This Answer Correct ?||0 Yes||0 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
we can eliminate duplicate values by camparision primary key
|Is This Answer Correct ?||1 Yes||7 No|
how to improve performence by using sorted input in aggrigator t/r.
tell me the informatica architecture
What is decode in informatica?
what is the diff b/w cached and unchaed look ups
How to load duplicate records in to a target table which has a primary key?
how to identify new and old values in source qualifier or any other transformations using informatica
What are the types of caches in lookup?
source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ
How will u pas the data with out debugger?
What is the advantage of persistent cache? When it should be used.
what is the incremental agrrigation?
why union is active transformation?