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

what is $$$$?

1724


What is the function of aggregator transformation?

569


Sequence generator, when you move from develoment to production how will you reset

1394


Which files are created during the session rums by informatics server?

697


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

1675






What are the main features of Oracle 8i with context to datawarehouse?

1669


How does a sorter cache works?

558


What is workflow? What are the components of workflow manager?

698


What is the need for an etl tool?

626


What is informatica metadata and where is it stored?

574


can we override a native sql query within informatica? Where do we do it?

617


what is INFORMATICA TESTING process

1830


What are the popular informatica products?

641


What is source qualifier transformation in informatica?

563


What is the command used to run a batch?

564