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 / preeti

hi,if I understand this question correctly,lookup itself
eliminate duplicate rows by having options like First
Value,Last Value.So whenever there are more than one row
for matching lookup condition then it gets eliminated by
first value.last Value option.Let me know if I am wrong

Is This Answer Correct ?    33 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Separate from a database, an information bazaar, and an information stockroom?

1082


COM components can be used in Informatica

2380


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1902


What do you mean by worklet?

1056


Can we create multiple integration service on single repository?

1182


Explian the Process of deployment groups in informatica

1059


Which are the different editions of informatica powercenter that are available?

1030


Explain pushdown optimization $pushdownconfig parameter - informatica

1123


Explain sessions?

1050


scenario where i can use only concurrent execution of workflow.

3161


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1078


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1895


tell me the rules and responsblites in our project(my project is development)

1929


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

2028


According to his methodology what all you need before you build a datawarehouse

1752