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

Answer Posted / chandra

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

Is This Answer Correct ?    0 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to do unit testing in informatica?

725


What is a pre-defined event and user-defined event?

580


differences between service based and product based?

1567


What is Data Caches size?

658


Explain the pipeline partition with real time example?

656






What is the difference between writing a joiner query in ANSI style and THETA style?

1925


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4317


What are the popular informatica products?

653


How do you change a non-reusable transformation to reusable transformation?

600


Explain lookup transformation in informatica

650


Which is the t/r that builts only single cache memory?

714


What is a sequence generator transformation?

578


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

634


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

774


What are Dimensional table?

620