Interested to Buy Any Domain ? << Click Here >> for more details...
hw cn v elimate dublicate values from lookup without
overriding sql?
- 7 Answers
- 17752 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 |
I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is the reusable transformation?
What are the new features of informatica 9.x in developer level?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
we have to use order by,where,having we to implement sql query
When do you use mapping parameters? (In which transformations)
What is update override?
Limitation of REPLACESTR. Is there any character limitation to it.
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
What is a router transformation?
Explain sql transformation in script mode examples in informatica
Teradata 
