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

Answer Posted / reddy

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

Is This Answer Correct ?    1 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

generate date / time dimension in informatica

705


Explain the code page compatibility?

626


How to update or delete the rows in a target, which do not have key fields?

643


What is the use of target designer?

593


How can you increase the performance in joiner transformation?

689






Explain sql transformation in script mode examples in informatica

589


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2047


Is it possible to revert a global repository to local one and why?

602


What the difference is between a database, a data warehouse and a data mart?

586


Define Pmrep command?

621


What are active transformations.

1173


What do you mean by filter transformation?

540


What is union transformation?

560


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

710


How to create the source and target database connections in server manager?

610