Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


hw cn v elimate dublicate values from lookup without
overriding sql?

Answers were Sorted based on User's Feedback



hw cn v elimate dublicate values from lookup without overriding sql?..

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

hw cn v elimate dublicate values from lookup without overriding sql?..

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

hw cn v elimate dublicate values from lookup without overriding sql?..

Answer / vijay

using dynamic lookup in lookup t/r we can easily eliminate
duplicates.

Is This Answer Correct ?    2 Yes 1 No

hw cn v elimate dublicate values from lookup without overriding sql?..

Answer / surender

yes correct

Is This Answer Correct ?    0 Yes 0 No

hw cn v elimate dublicate values from lookup without overriding sql?..

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

hw cn v elimate dublicate values from lookup without overriding sql?..

Answer / chandra

in the source qualifier select the prequalifier and select
the distinct clause

Is This Answer Correct ?    0 Yes 6 No

hw cn v elimate dublicate values from lookup without overriding sql?..

Answer / reddy

hi,
we can eliminate duplicate values by camparision primary key
using lookup

Is This Answer Correct ?    1 Yes 7 No

Post New Answer



More Informatica Interview Questions

how to improve performence by using sorted input in aggrigator t/r.

2 Answers  


tell me the informatica architecture

1 Answers   Banca Sella, Wipro,


What is decode in informatica?

0 Answers  


what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,


How to load duplicate records in to a target table which has a primary key?

2 Answers  






how to identify new and old values in source qualifier or any other transformations using informatica

2 Answers  


What are the types of caches in lookup?

0 Answers  


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

2 Answers   Wipro,


How will u pas the data with out debugger?

4 Answers  


What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,


what is the incremental agrrigation?

2 Answers   Cap Gemini,


why union is active transformation?

4 Answers   IBM,






Categories