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

What is data transformation manager process?

1220


how many types of dimensions are available in informatica?

1176


How to generate or load values in to the target table based on a column value using informatica etl tool.

1112


How to create or import flat file definition in to the warehouse designer?

1130


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9896


How many dimensions are there in informatica?

1134


Why update strategy and union transformations are active? Explain with examples.

1284


Can we change Dynamic to Static or Persistent cache? If so what happens?

2248


permutations of mapplet

2548


What are the components of workflow manager?

1153


State the limitations where we cannot use joiner in the mapping pipeline?

1106


Describe data concatenation?

1123


Could you explain what is enterprise data warehouse?

1224


Partition, what happens if the specified key range is shorter and longer

2550


What is native users?

1222