hw cn v elimate dublicate values from lookup without
overriding sql?
- 7 Answers
- 15569 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 |
When do you use sql override in a lookup transformation?
Can we create out put ports in source qualifier t/r?
What is substr in informatica?
What are the Advantages of de normalized data?
Briefly define reusable transformation?
Why we use ENABLE HIGH PRECISION in session properties?
Without using any transformations how u can load the data into target?
any body can say about all versions of informatica ?how many versions ?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is aggregate awareness?
what is the process we used in joiner transformation,there is no matching column in sources?
What do you mean by enterprise data warehousing?
Teradata 
