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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you update the records with or without using update strategy?

665


update strategy transformation in informatica

644


What are the guidelines to be followed while using union transformation?

642


Difference between Data and Index Caches?

661


complex mapping ur project u r invlve can u explain and give real time example give me ?

1845






How can you differentiate between powercenter and power map?

626


What do you mean by blocking transformation?

585


Why is sorter an active transformation?

667


While importing the relational source definition from the database, what are the metadata of source that will be imported?

795


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1905


How many ways are there to create ports?

731


How does a rank transform differ from aggregator transform functions max and min?

676


in reporting we add some new objects,how we get the count of the newly added objects to the report

1753


Reusable transformation and shortcut differences

1382


What is a filter transformation?

573