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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you generate reports in informatica?

582


How can one identify whether mapping is correct or not without connecting session?

883


What is standalone command task?

713


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3326


How do you load alternate records into different tables through mapping flow?

1298






What are the new features of informatica 9.x at the developer level?

609


While migrating the data from one environment to another environment how would you manage the connections?

627


In warehouses how many schemas are there?

584


Define Pmrep command?

642


Differentiate between source qualifier and filter transformation?

1003


What is decode in static cache?

596


Explain informatica architecture - version 8 / 9

671


Explain about cumulative Sum or moving sum?

622


What is a sequence generator transformation?

577


How to create Target definition for flat files?

755