Interested to Buy Any Domain ? << Click Here >> for more details...
hw cn v elimate dublicate values from lookup without
overriding sql?
- 7 Answers
- 18034 Views
- CTS, I also Faced
- E-Mail Answers
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 |
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
What is rank transformation in informatica
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
What is critical mapping?
Can any body tell about the (UTC) unit test cases with the examples in informatica.
Hey I am net to informatica? Can any one explain me step by step How scd will work ?
What is version control in informatica ? Advance thanks
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
expain about the tune parameters?
What are the different types of Type2 dimension maping?
Informatica settings are available in which file?
Teradata 
