Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Explain about cumulative Sum or moving sum?

1035


What do you mean by enterprise data warehousing?

1058


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1784


What are the uses of etl tools?

1121


how many types of dimensions are available in informatica?

1085


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2123


How to implement security measures using repository manager?

1165


Clarify the utilization of aggregator cache record?

987


update strategy transformation in informatica

1060


differences between service based and product based?

2007


How to generate sequence numbers using expression transformation?

1082


How to improve the performance of a session using sorter transformation?

1142


Name at least 5 different types of transformations used in mapping design and state the use of each.?

1150


How do you load first and last records into target table?

1152


What is aggregate cache in aggregator transformation?

1135